Migrate from Access 2000 to SQL Server 2008

Posted on 2011-10-10
Medium Priority
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

Accepted Solution

yatin_81 earned 2000 total points
ID: 36944615
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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

621 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