Importing a text while and saving the autonumber field

[PKM]

Access 97 -

I am exporting tables from one database and importing them into another database.
The export is text, comma delimited, with quotes around the text.
When I import a few of the tables, I want to preserve the autonumber in the autonumber field of the orginal table. But when I import as an autonumber field it reassigns the number starting with one.
In the new database I can not change the field type.

Thank You

 

[young]

Try copy the table you want to export as backup, change auto number to long interger, and then export.