Importing Data and Primary Key

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

learningaccess - 29 Jun 2007 19:14 GMT

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

Signature

Thanks!

Reply to this Message

Jerry Whittle - 29 Jun 2007 19:38 GMT

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.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> 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
[quoted text clipped - 9 lines]
> Thank you.
> Chris

Reply to this Message

learningaccess - 29 Jun 2007 21:04 GMT

Thank you!! Have a nice weekend.
Chris

Signature

Thanks!

> 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
[quoted text clipped - 13 lines]
> > Thank you.
> > Chris

Reply to this Message