My destunation table in SQL Server has an Identity Column. The rest of the columns are identical to the source table in Access. I need that identity column as unique identifier.
When I Import the records from Access to SQL, I got error message saying I am attempting to insert NULL value into my identity column. Yet, I have already set that column to have identity seed of 1, and I would expect the rows being inserted with incremental numbers in that column. AM I right?
Anybody has any information to share on this? I appreciate it.