I am trying to migrate to SQL 7.0 . I am using upgrade wizard of Access , however there is a table with half a million records and this is causing a problem. Anyone has ever handled real huge data transfer between Access and SQL 7.0 would welcome some tips.I do want to use the DTS of SQL cuz then my primary key which are autonumber gets disturbed when it goes to SQL.<BR>Or do you think I shoudl first create the table in SQL with keys and then just use DTS to port the data. Does the auto number still work??