Access 2007 Move Data SQL 2008

Posted on 2008-11-14
Last Modified: 2012-05-05
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.
Question by:CatsSolutions
    LVL 84
    What version of SQL Server are you moving to?

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

    Accepted Solution

    Sorry, didn't see your tag for 2008 ... the link above also includes a utility to move to 2008. Good luck!!
    LVL 84
    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 ...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now