• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 721
  • Last Modified:

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.
0
CatsSolutions
Asked:
CatsSolutions
  • 3
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What version of SQL Server are you moving to?

If you're moving to SQL Server 2005, you can also use this:

http://www.microsoft.com/sqlserver/2005/en/us/migration-access.aspx
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Sorry, didn't see your tag for 2008 ... the link above also includes a utility to move to 2008. Good luck!!
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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 ...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now