How to Convert .MDB file to .MDF in SQL Server 2005

• khandaresarang

  Mr or Mrs. 500

  Points: 532

  More actions

  September 13, 2009 at 10:53 pm

  #141725

  Hi all,

  I want to convert .MDB file to .MDF file in SQL Server 2005 Express Edition.Can any one help me regarding this.

  Thanks in advance.......

• Robbert Hof

  SSCrazy

  Points: 2778

  More actions

  September 14, 2009 at 7:29 am

  #1053186

  Connect to the sql server using management studio.

  Then right click on the database where you want the data to be imported (or create a new one)

  Select tasks/import data. Select as Data source: Microsoft Access.

  Point to the .mdb and follow the wizard-steps.

  HTH

• psvirin

  Mr or Mrs. 500

  Points: 542

  More actions

  September 14, 2009 at 3:45 pm

  #1053478

  MSSQL Express 2005 has no SSIS but it has SQL Server 2005 Backwards Compatability Components that includes DTS2000 Runtime.

  Look here to see how to use this tool to import MDB.

  -------------------

  StarWind Software developer ( http://www.starwindsoftware.com )