Out of Sequence Autonumber after Excel Import

[Hillary]

I have a new database I am testing the import function on. I imported some data from Excel. In the Access Table there is an Autonumber field. Before I imported the last autonumber was 77. When I imported the records it assigned the first imported record autonumber 453054332; and +1 for each additional record. When I manually add new records it gives me the next sequential large autonumber.

Why is this happening?

Do I have to worry about this autonumber getting too large? It is a brand new database.

Thanks for any input.

Hillary

 

[KenReay]

Hi

Autonumbers cannot necessarily be relied on to be sequential

They are not meant to have 'meaning' they are simply a unique id

If you delete all rows from the table and compact the database the autonumber (for that table) will restart at 1

Autonumber is a long integer, so the maximum number is as per a long integer (-2,147,483,648 to 2,147,483,647), so you will only run out of numbers if you add more rows than this range Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK