G Guest Jan 12, 2005 #1 I would like to know if it is possible to import data into an autonumber field and maintain the current data in the field.
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 Jan 12, 2005 #2 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?
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 Jan 12, 2005 #3 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]
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]
