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

R

Ram

I would like to know if it is possible to import data into an autonumber
field and maintain the current data in the field.
 
L

Lynn Trapp

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?
 
J

John Vinson

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]
 
Top