Thread: Access 97 to SQL 2k Primary Keys
08-13-03, 12:56 #1Registered User
- Join Date
- Mar 2003
Unanswered: Access 97 to SQL 2k Primary Keys
I'm importing data in about 350 tables from Access 97 to SQL Server 2000 and the primary keys in the tables aren't kept after the import.
Is there a way to prevent this other than going through 350 or so tables and manually setting the primary key?
What's the best way to handle Autonumber fields?