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?