?
Solved

Migrate from Access 2000 to SQL Server 2008

Posted on 2011-10-10
1
Medium Priority
?
266 Views
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?
0
Comment
Question by:hrolsons
1 Comment
 
LVL 2

Accepted Solution

by:
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..
0

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