deha
deha

Reputation: 815

How move data from mssql database to Access?

I have to move some data 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?

Upvotes: 1

Views: 1848

Answers (1)

Jahan Zinedine
Jahan Zinedine

Reputation: 14874

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

Upvotes: 2

Related Questions