How to convert .mdf file to Access format?

I have a database file with .mdf extension. I am not sure what database format this is, possibly SQL.
How do I convert this to Access?

Who is Participating?
Steve BinkConnect With a Mentor Commented:
Where did you get the database file?  .MDF is the standard extension used by SQL Server, so it's a good bet that's where it came from.  I know of no way to import from that file other than attaching it to an MSSQL instance and linking to it from Access or exporting it from MSSQL.
SidFishesConnect With a Mentor Commented:
mdf is generally mssql

afaik you can't  "convert it"

you need to import the data so you need a running copy of mssql and do a get external data -> import

if you don't have mssql get MSDE from MS, install and use that...

rj94070Author Commented:
I have access to the original program where the .mdf file comes from.
This means if I run the original program, the mssql is running. True?

Then I can bring up Access and do the Get External Data ... Import??

Thanks for clarifying.
Steve BinkConnect With a Mentor Commented:
Yep, that's it, assuming that is an MSSQL file.  If you can manage to attach it to MSSQL, you should be able to read it through ADO or ODBC with no problems at all.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.