Hi, I need to salvage data from an SQL Server database and put it in access or Excel. This is from an old medical software that is going out of business. The clinic wants to get the data out of the sql server database and store it in access as a temporary measure. Table relationships, reports and stored procedures are not important in this case. I have the raw database files .mdf and ,ldf. Is there a way I can do this? It seems a simle task but I don't see any tools in SQL server that would let me do this. I also don't see any tools that would let me import into Access. If I export the database into and sql file can I somehow import it into access?

Can someone advise? Thank you!

OK. This is what I did so far...

1.) Attached databases in SQL Server

2.) Created ADP files in Access and pulled in the database

3.) Created simple Access file and exported tables from ADP into Access.

Works fine this way but I have to export the tables one by one (there are hundreds of them in several SQL databases.

saburius:

Hi, I need to salvage data from an SQL Server database and put it in access or Excel. This is from an old medical software that is going out of business. The clinic wants to get the data out of the sql server database and store it in access as a temporary measure. Table relationships, reports and stored procedures are not important in this case. I have the raw database files .mdf and ,ldf. Is there a way I can do this? It seems a simle task but I don't see any tools in SQL server that would let me do this. I also don't see any tools that would let me import into Access. If I export the database into and sql file can I somehow import it into access?

Can someone advise? Thank you!

Hi saburius,

I think you can use the Import and Export Wizard to translate the data between SQL Server (data source) and Access (destination).

Please have a look at the following links:

How to: Start the SQL Server Import and Export Wizard
http://msdn.microsoft.com/en-us/library/ms140052.aspx

Importing and Exporting Data by Using the SQL Server Import and Export Wizard
http://msdn.microsoft.com/en-us/library/ms141209.aspx

You can also use some third-party tools to convert a SQL Server database to Access.