Post reply

Convert Access .mde to sql database

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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply