How to export tables from SQL server to MS-Access

Bhaskara123

Registered User.
Local time
Today, 05:14
Joined
Mar 26, 2007
Messages
11
Hi all,

I have faced with one problem that is how to export Tables from SQL server to MS-Access.

could anyone plz help me

Thanks,
Bhaskar.
 
Is this a "one-time" thing or an on-going thing?

If one-time only, why not use File > Get External Data > Import from the Access database? If an ongoing thing, you can either link the tables, or setup a import into Access from Access, or you should be able to use DTS in SQL to do it.
 

Users who are viewing this thread

Back
Top Bottom