Post reply

Import Access 2010 db to SQL Server

  • March 14, 2013 at 11:32 am

    #394394

    I am trying to import a .accdb file into SQL Server but do not see any option in SQL Server Import Wizard. There is an option of importing a .mdb file but not .accdb file.

    Does anyone know how to import such a file to SQL 2008?

    Thanks

    KK

  • March 14, 2013 at 12:12 pm

    #1597196

    Under Choose Data Source, use Microsoft Office 12.0 Access Database Engine OLE DB Provider - "Microsoft Access" is for Office versions lower than 2007

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • March 14, 2013 at 12:33 pm

    #1597200

    Yes, that worked. Thanks!

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

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