General discussion

Locked

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.

3 total posts (Page 1 of 1)  
| 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

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acconWhenToUpsizeMDBtoSQLServer.asp

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Forums