Importing data from SQL server 2000 to MSaccess

• assh1122

  SSC-Addicted

  Points: 449

  More actions

  June 2, 2010 at 6:57 pm

  #223365

  Hi All,

  I have .mdf SQL Server 2000 data files. I need to convert this to .mdb MSaccess database. Could anyone please let me know how to do this? I appreciate your help.

  Thank you,

  assh

• balaji.ganga

  SSCrazy

  Points: 2280

  More actions

  June 3, 2010 at 4:26 am

  #1175804

  Hi,

  you just restore that mdf file, then you have to export those tables to access.

  I thing it's not possible convert from mdf to mdb.

  Thanks & Regards

  Balaji.G