.DBF to a .MDF, Do I need to? RRS feed

  • Question

  • User844067326 posted


    How can I import a DBF file into a .MDF file?

    Do I need to? I have it connected with a ODBC.

    I am tring to make a databse interface suing ASP.NET 2.0 and Visual Web Developer.


    Do I need to import a DBF or can I just link?

    It seems the .MDF files have more funciallity



    Thursday, July 6, 2006 2:52 AM

All replies

  • User-820230059 posted

    A DBF is an Access database file, an MDF is an SQL Database file, your free to use either, they each have nearly identical program support inside an asp.net 2.0 application, the different being scaleability.

    If you want to get your DBF to an MDF, you should run a DTS command on the DBF to migrate the data into a new SQL database.

    Thursday, July 6, 2006 9:22 AM
  • User143635943 posted

    .DBF is not Ms Access format. It's Fox pro database. By using ODBC you can connect to .dbf file.
    If you want more relational database management features like relationship among tables, powerful indexes, store procedures then only switch to SQL Server.


    Kuldeep Deokule

    Thursday, July 6, 2006 10:19 AM
  • User-820230059 posted

    Sorry, your right, I was thinking MDB (access) and DBF (foxpro and db2) and my fingers typed exactaly the oposite of what I was thinking.


    Thursday, July 6, 2006 5:04 PM
  • User844067326 posted
    OK. How do I "run a DTS command on the DBF to migrate the data into a new SQL database." Do I need to convert if I just want to post data as a table and a querry to filter?
    Saturday, July 8, 2006 7:00 PM
  • User-820230059 posted

    In your SQL manager, there's an option to run a DTS Import, it's wizard based if you want it to be, normally you can find it under the tools menu.


    Sunday, July 9, 2006 7:57 AM
  • User1304996184 posted

    i need to import the .dbf data into .mdf database, i have no idea for this at all, can any one help . thanks a lot. may i know what is DTS.   how to use that, except that function, still have other way to import the dbf database to mdf database? thanks for u all help.

    Tuesday, July 15, 2008 12:19 AM
  • User1458538031 posted

    hello dear i need your help

    i think u done it

    dbf file is now convert into sql format kindly need this plz help me

    Wednesday, November 18, 2009 1:10 PM
  • User-319574463 posted

    Which version of SQL Server are you using?

    If SQL2000 (or earlier), you will need to use DTS for for SQL2005 or SQL2008 you will need to use Sql Server Management Studio (SSIS) and Import the Data to SQL Server.

    Saturday, November 21, 2009 2:54 PM
  • User1458538031 posted

    thanks for reply.


    i handel this .

    Monday, May 2, 2011 7:05 AM
  • User1096912014 posted

    If you need to import just a single DBF file into SQL Server, then the solution depends on which SQL Server you have installed (32 bit or 64 bit). The complete solution you can find in the following blog post


    Monday, May 2, 2011 11:14 AM