DTS is the easiest way to do this. Open a new package, add a connection to SQL Server and one to your access db. specify your view and destination table, then you can map the columns between them.
You could also link to a SQL Server view from Access and get the data that way.
Either of these topics are discussed in the help files for the products.