Resetting autonumber when importing

[bullwinkle55423]

I have a table set up that I import an Excel file to. This table has an autonumber field to keep the sequence of the rows set. Before I do an import, I delete all of the records form the import table. However, the autonumber field starts with the last number used and it is getting to be a pretty large number.

Is there a way, either in the table properties or via VBA code, to reste the autonumber to 1 or some other number.



Thank you for your help.

[RuralGuy]

You should find this link helpful.

[bullwinkle55423]

I tried the code that you provided, but it didn't seem to reset the autonumber. And as I looked at the code, it appears to only work if I want to set the counter higher. (If the highest number is 500, I can make the next one 1000). But it doesn't let me reset it back to 100 or 1.

Am I missing something?

[RuralGuy]

With all of the records deleted, if you Compact and Repair the AutoNumber seed is set back to 1.