Autonumber Field Increments Incorrectly When Importing from Excel

[Guest]

Hello,

I have set up an Excel spreadsheet to collect project information from
users. Once the spreadsheet is complete, I import the sheet to my project
tracking database.

The project tracking database assigns a project ID number when new records
are added. This field is set to datatype AutoNumber, field size Long
Integer, new values Increment, and indexed Yes. I left the project ID field
out of the Excel spreadsheet. When I import data from the Excel worksheet, a
new record is created in the database as expected. The project ID number is
not the next incremental number, however. Instead, Access assigns a number
like 33885806 when the next incremental number is really 102.

Any ideas what I am doing wrong?

Thank you!
Tom

 

[Jeff Boyce]

Autonumbers in Access are designed to provide a (generally) unique row
identifier, especially if you are going to be relating rows in one table to
rows in another. The Autonumber field is expressly NOT suitable for human
consumption.

If the "ID" number you are using is to be displayed to humans, consider
checking Google.com or the mvsp.org websites under the search term "custom
autonumber". You'll need to "roll your own" ID to get/keep a sequential
numbering system.

 

[Jeff Boyce]

Should have been

mvps.org

sorry for the typo

Jeff

(this may duplicate another response, which my emailer "bounced" back at me)