Web Development

General discussion


Access to SQL conversion

By robert.marsh ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by cmiller5400 In reply to Access to SQL conversion

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

Collapse -

by cmiller5400 In reply to

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

Collapse -

by mark In reply to Access to SQL conversion

Access 2000 has an Upsizing Wizard.

"Tools - Database Utilities - Upsizing Wizard".

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

Further info : http://www.microsoft.com/presspass/press/1999/Jun99/AccMigpr.asp


Related Discussions

Related Forums