Extract all table data from SQL Server

[RichO]

I had asked a previous question about a SQL server issue and worst case scenario, if the problem can't be fixed by a tech without spending a lot of money, I may have to go to using a regular MS Access back end.

If this is the case, is there a way to extract all of the table data stored in SQL server and export it as an mdb? I have tried to do this using the export wizard in Enterprise Manager but when I select MS Access as the destination format I get some kind of error about the class not being registered.

 

[SQL_Hell]

If the export to access option didn't work, try exporting to .csv and importing to access that way.

What is the issue that is causing you to think down grading to access is an option? seems a bit drastic.

 

[RichO]

There are about 50 tables in SQL server. Would exporting to CSV create a separate file for each table?

Outdated version of SQL server, outdated Win 2000 OS on that computer, can't afford to upgrade and having major connection issues:

http://www.access-programmers.co.uk/forums/showthread.php?p=1333527#post1333527

 

[RichO]

At the risk of sounding dumb, what is FE? Everything having to do with exporting from SQL server goes to the same wizard and there are options such as "Microsoft Access Treiber" but that is requiring a DSN and I have no idea where to go from there, or what a treiber is.

 

[RichO]

Yes, using MS Access front end

 

[Rx_]

http://softwaresolution.informer.com/Export-SQL-to-MS-Access/
Found this site, have no experience with it except for the last on on the list.
The last one only migrates MS Access to SQL Server.

If you can re-establish just one MS Access linked tables to SQL Server...
Several of us can help you with automation code that could Make Tables, then move the data over.
You may still have a lot of problems or manual process with the primary keys.

Also: attached is a screen shot of the SQL Server Import and Export Wizard.
Can't claim to have used that for exporting to Access.