How move data from mssql database to Access?

I have to move some da开发者_JS百科ta from sql server to access database. In target access database there are ready tables, I need to move only records. Some of them will require some changes, like crossing two tables from sql server to one access database. Do you know how to do that?

Use the Sql Server Integration Service and write a custom sql query in the step that prompts you to select tables or write a query