Creating a database from .mdf file in MS Access

Question

I have a .mdf which I need to import into MS Access. I have read that .mdf is a Sql Server format so Access wont recognize it. But is there some way I can get the database created in MS Access. I am using Access 2003 and Sql Server 2005

open up SSMS and right-click ATTACH the database. I do this a dozen times a day, it's quite simple. — Aaron Kempf
– Aaron Kempf, Commented Apr 22, 2011 at 19:26
That's an answer, Aaron, not a comment. You should post it separately, but you should add to it the fact that you have to have SQL Server installed. — David-W-Fenton
– David-W-Fenton, Commented Apr 25, 2011 at 23:46

Hemant · Accepted Answer · 2009-03-23 08:06:59Z

2

Why not right click the database in SQL Management Studio, click export and then specify the required parameter?

I just checked. Works in my installation of SQL Server 2008.

answered Mar 23, 2009 at 8:06

Hemant

19.9k24 gold badges95 silver badges131 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Cerebrus · Accepted Answer · 2009-03-23 08:06:55Z

0

You could create a new Access database and import the tables from the mdf file into it. You have not mentioned the version of Access or SQL server so it's difficult to be more specific.

Alternatively, if you have access to an SQL Server, you can export the database as an Access .mdb.

answered Mar 23, 2009 at 8:06

Cerebrus

25.8k8 gold badges58 silver badges71 bronze badges

Collectives™ on Stack Overflow

Creating a database from .mdf file in MS Access

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related