importing access 2007 to sql 2014 express

• greg 17323

  SSC Rookie

  Points: 35

  More actions

  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.

• Eirikur Eiriksson

  SSC Guru

  Points: 182945

  More actions

  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.