Importing records - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Importing records

Gary Smith

5 years ago

Hi Richard,

After using Excel for many years I now record my business invoices in Access thanks to your tech help videos.

I started my Access Autonumber InvoiceID from #462 using this query:

ALTER TABLE [InvoiceT]
ALTER COLUMN [InvoiceID] COUNTER (462,1)

Is it possible to now import my old Excel Invoice data from Excel and put it into access before that number ? ie Invoices #1 - 461 ?

Thanks Gary.

Scott Axton @Reply

5 years ago

Wow this question hasn't surfaced in a while...
Here is a word of caution:
The auto number field is a field for ACCESS to use,  NOT YOU.
See the   Auto Numbers Good or Bad video.

The best solution would be to create your own Number field that you and the customer see and use and leave the InvoiceID field alone.  This is explained better here:  Custom Sequential Number

As a last resort check out the Restore Deleted Autonumber video.
Go all the way to the bottom first and read Richards Post about the video.

	Richard Rost @Reply 5 years ago
^ What Scott said. :) Autonumbers are not for YOU. They're for Access to make RELATIONSHIPS. That's it. If you care about those numbers, put them in a secondary field for YOU.

	Gary Smith OP @Reply 5 years ago
Thanks Guys, after watching the Custom Sequential Number video ive fixed the problem. All is not lost !

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen