[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2568
  • Last Modified:

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?

  • 2
3 Solutions
Steve BinkCommented:
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.
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 BinkCommented:
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.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now