CatsSolutions
asked on
Access 2007 Move Data SQL 2008
Hi All,
I have a 2007 access Database which I wish to move to a SQL Server Backend. When I use the upsize wizard I get the following error "The upsizing wizard only works with Microsoft SQL Server (Versions 6.5 sp5 or higher). Please log in to a sql server data source.
I have also tired to use existing database with a file dsn??
Any help will be deeply appreciated.
I have a 2007 access Database which I wish to move to a SQL Server Backend. When I use the upsize wizard I get the following error "The upsizing wizard only works with Microsoft SQL Server (Versions 6.5 sp5 or higher). Please log in to a sql server data source.
I have also tired to use existing database with a file dsn??
Any help will be deeply appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So I provide you with a link to a FREE utility that does exactly what you ask, and you grade this a B? What, in your opinion, would deserve an A grade - if I come to your location, at my own expense, and do the upsize for you? Geez, sometimes I wonder why I bother with this forum ...
If you're moving to SQL Server 2005, you can also use this:
http://www.microsoft.com/sqlserver/2005/en/us/migration-access.aspx