How to convert .mdf file to Access format?

Posted on 2005-04-18
Last Modified: 2012-05-05
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?

Question by:rj94070
    LVL 50

    Accepted Solution

    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.
    LVL 36

    Assisted Solution

    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...


    Author Comment

    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.
    LVL 50

    Assisted Solution

    by:Steve Bink
    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

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Suggested Solutions

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now