Migrate from Access 2000 to SQL Server 2008

Posted on 2011-10-10
Last Modified: 2012-05-12
I would like to migrate from Access 2000 to SQL Server 2008.

I ran the wizard in Access and it crashed.

I ran the SQL Server Migration Assistant and it doesn't recognize my Access 2000 db because it's 32-bit.

Can someone please help?
Question by:hrolsons
    1 Comment
    LVL 2

    Accepted Solution

    You can user Data Transformation Service available in SQL Server 2008 Management Studio. Right click on database and choose Task-> Import Data and select Microsoft Access as Data Source..

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    754 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

    22 Experts available now in Live!

    Get 1:1 Help Now