Loading

MS SQL Server to MS Access

Abhimanyu K Vatsa

hello....

is there any way to Export Microsoft SQL Server 2005 Database Table exist on Remote Database Server to MS Access Database Table for client or say for local use by client. Actually one of my client is asking to have MS Access Database for his personal use.

There is many 3rd party software to accomplish this but I am not wishing to purchase it.

Please help me with another way

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhimanyu K Vatsa16y ago
thanks for reply

that's fine....but i am wishing to have a technique like query execution.
0
Manikavelu Velayutham16y ago
Make a new Access database. Go to the tables tab and right click in the large whitespace area. Select Import. You'll need an odbc connection to your SQL database. You can import all of your tables at once.
0