Discussion Locked

Access to SQL conversion

0 helpful

3 replies

by robert.marsh Apr 5, 2006 last reply May 2, 2006

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an Access 2000 database that I need to convert to SQL2000. Is there a basic macro or script available that I can modify to use in this task?

3 replies

Use DTS (data transformation services) to import the data from the Access database to the SQL database.

The DTS should be in the program group for sql server.

Access 2000 has an Upsizing Wizard.

"Tools - Database Utilities - Upsizing Wizard".

You can use an existing SQL Server database, or create a new one.

This discussion is closed to new replies.