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

[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.

 

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

 

[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.

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]