title: Enable identity insert is not working when importing data
body: <p>I am trying to import many tables from access db to MS SQL server using the import wizard.
  Some rows in source tables has been deleted so the sequence of IDs are like this: 2,3,5,8,9,12,...</p>
  
  <p>but when I import the data into my destination, the IDs start from 1 and increment by 1, so they don't exactly match with source data.</p>
  
  <p>I even check the "Enable Identity insert" but it does not help. 
  The only work around I have found is to change the IDs in destination tables from Identity to integer one by one, then import, and then change them back to identity, which is very time consuming.</p>
  
  <p>Is there any better way to do this?</p>