Import from MS Access and Keep Auto Increment keys?

[imstillatwork]

Is it possible to migrate or import from MS Access (2002-2003) and keep the integrity of the auto increment references? It's really important not to loose them!

For instance: product 'x' in the database is Product_ID 3. I have 100's of links coming in refering to individual products. If I just reinsert the data into a new datsbase, those links will not be accurate.

Is there any way to keep the auto ids from access????

Thanks!!!

 

[r937]

yes, just keep them

mytsql is very forgiving, if you insert a row and provide a value for its auto_increment column, mysql will accept it

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts July 10 2005)

 

[imstillatwork]

hmm.. access and mssql are so strict about that I didn't even think of it! Thanks!

Now I'm having trouble getting any data out of the migration tool kit..

The inserts file I am saving is basicly empty? the create file has all the table info just fine though... can't figure it out, tried a few times.