Importing Data and Primary Key

G

Guest

Hi ... I just imported 34 excel files into an access table. Access
designated a primary key for me. The first of the 34 files were numbered 1
to 23603. The remaining rows of data from the other 33 files jump suddenly
and are numbered 82185569 thru 82721859. There are a total of 559893 rows of
data. I don't see any blank rows between 23603 and 82185569.

Does it matter that there was a large jump in primary key from 23603 to
suddenly 82185569? Can I work with the database like this? Or, can/should I
renumber the primary key somehow to be 1 thru 559893?

Please let me know.
Thank you.
Chris
 
G

Guest

Don't worry about it. An autonumber field that is also a primary key is only
guarenteed to be unique. There are many things that can cause jumps in
numbers. You might even see some negative numbers.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missing Primary Key and Scrambled Data 1
error message importing excel 2
Primary Key Number 1
Access 2007 to SQL 2008 - primary and foreign key types 3
Importing Excel Data 6
Importing Data when primary key already exists 2
Importing Excel sheets 7
Importing SSNs from Excel into access 2007 and using as primary ke 1

Top