change to Auto number

  • Thread starter Thread starter Guedj54
  • Start date Start date
G

Guedj54

I have imported data to access (field name: Product_ID, Data type:
Number) from excel. All fine.
It is a list of ID at random increment (1,2,9,10,11,12,24,25,26,27…)
Now the problem is that I will need to change the Data Type to
AutoNumber from now on with a fix increment of one
(27,28,29,30,31,32…), since I will be populating the table it belong
too through access.
Access does not let me change the data Type to AutoNumber .

Any ideas?
 
(e-mail address removed) (Guedj54) wrote in
Access does not let me change the data Type to AutoNumber .
Click to expand...

Create a new table with all the fields as you want them, but with the AN
field set to autonumber rather than integer. Then append the existing data
with an INSERT query. Any new records will carry on incrementing the AN
field from the highest-so-far. I'm not completely sure what will happen if
you put a negative number into a Autonumber field...

B Wishes


Tim F
 
Back
Top