Convert Access .mde to sql database

• dpcr

  SSC Veteran

  Points: 228

  More actions

  December 9, 2009 at 3:09 pm

  #73413

  Hi,

  I'm able to see the structure and a data of the access .mde file using a data connection in Visual Studio 08. Is there a way to then use this to create a sql database? Complete conversion would be ideal(structure and data) but schema would be ok too.

  Thanks for any help.

• Chris Quinn-821458

  Hall of Fame

  Points: 3192

  More actions

  January 29, 2010 at 3:40 am

  #1110604

  From SQL Management Studio, create an empty database to hold the tables you wish to import.

  Right click on the database name, then choose Tasks/Import data from the popup menu - you should then be able to connect to the access database and import the tables - Select Microsoft Access as the data source - the rest of the process is fairly easy to work out