Migrating ACCESS tables to SQL SERVER 2012 problems

[Colm Kavanagh]

I am trying to migrate tables from my Access 2007 database to a new SQL SERVER 2012 db using the upsizing wizard but get the following error "The Upsizing Wizard does not work with the version of MS SQL Server to which your Access project is connected. See the Microsoft Off ice Update Web site for latest information and downloads"

I can't find anything on the website. Anyone know what I need to do to resolve this problem?

thx
Colm

[rpresser]

Post by Colm Kavanagh
I am trying to migrate tables from my Access 2007 database to a
new SQL SERVER 2012 db using the upsizing wizard but get the
following error "The Upsizing Wizard does not work with the
version of MS SQL Server to which your Access project is
connected. See the Microsoft Off ice Update Web site for latest
information and downloads"

Try using this tool instead:

Microsoft SQL Server Migration Assistant for Access v5.2
http://www.microsoft.com/en-us/download/details.aspx?id=28763

[Colm Kavanagh]

thanks but unfortunately I am having problems using this tool. I selected tables and queries from the Access db but when I do the migration I get the error "There is nothing to process". Don't understand why it thinks that as I selected the tables and queries to be processed.

Any clue as to what might be happening here?