Post reply

importing access 2007 to sql 2014 express

  • March 24, 2014 at 11:33 am

    #284921

    Anyone know of a way to move tables from access 2007 to SQL 2014 express?

    The import export data tool that comes with it will not even think about importing the indexes keys/autonumber.

    Migration assistence says it is not compatible and simply doesn't work

    Access 2007 upsizing only has the option of using SQL 2012 and errors out when I try.

    Any suggestions would be a great help.

  • March 30, 2014 at 11:04 am

    #1701431

    Several ways to do this, options include using SSIS package, an OPENROWSET from destination, downgraded SQL Server import then upgrade and few more. Without more knowledge of the schema, constraints etc. it is hard to recommend any specific method, but as mentioned earlier, quite few options are available. 😎

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

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