How do I import data from an Access 2000 database to SQL Server 2000. How do I go about this?

-- Anonymous, September 05, 2002

Answers

Jane,

The Access 2000 Upsizing Wizard does not support upsizing to SQL Server 2000. You can work around this by using Data Transformation Services in the Enterprise Manager to import your MDB database file into SQL Server. You can then rename your MDB tables and create linked tables to the resulting SQL Server database with the same names as your original MDB table names.

Or, upsize to SQL 7 and then upgrade SQL Server.

Hope this helps,

Eric

-- Anonymous, September 06, 2002