• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 719
  • 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

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

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