Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

importing access 2007 to sql 2014 express Expand / Collapse
Posted Monday, March 24, 2014 11:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 24, 2014 11:22 AM
Points: 1, Visits: 0
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.
Post #1554166
Posted Sunday, March 30, 2014 11:04 AM


Group: General Forum Members
Last Login: Today @ 4:44 AM
Points: 6,549, Visits: 17,225
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.
Post #1556290
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse