How do I insert into an autonumber field, similar to Identity Ins.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to know if it is possible to import data into an autonumber
field and maintain the current data in the field.
 
You can insert a new value into an autonumber field. You can update data in
other fields that have an autonumber field in the record. Is this what you
are asking for?
 
I would like to know if it is possible to import data into an autonumber
field and maintain the current data in the field.
Click to expand...

An Append query, appending a Long Integer value into an Autonumber
field, is about the only way to do this.

As a rule, it should NEVER be necessary to do so. Autonumbers will
always have gaps; if gaps aren't acceptable - don't use Autonumbers.

John W. Vinson[MVP]
 
You must log in or register to reply here.

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

Autonumber records inserted in gaps 1
Autonumber field changes to random from sequential 3
Autonumber as Primary Key and Relationships 0
Change the starting value of an AutoNumber field 3
Import data into a table with an autonumber field 2
Changing a number field to Autonumber 5
"Multiple Autonumber" in same table 2
What are AutoNumber Dangers 11

Back
Top