To import Data from mdf file to Access.

[ragpark]

How do I import data from an SQL server's data file (*.mdf)
to an Access Database directly with out using the SQL server? That is I do not want recover it into SQL Database
and then importing to Access.

 

[tcurtis]

Have you used the import wizard?

 

[tlbroadbent]

You can't import to Access from a SQL Server MDF file. You need to run SQL Server and have the MDF file attached as a database.

However, the good news is you may not need the full version of SQL Server. You may be able to use MSDE. If you don't know what MSDE is check this link.

SQL Server 2000 Desktop Engine (MSDE 2000)

http://www.microsoft.com/SQL/techinfo/development/2000/msde2000.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.