"Excel 009" <ex***********@gmail.comwrote in message
news:87**********************************@w1g2000p rd.googlegroups.com...
Hi,
Is there a way to populate sequential numbers in a field using SQL or
VBA? If yes, how?
Assume the following is my existing table:
Fruit ID
Apply
Banana
.
.
Orange
and I want to populate the ID field with 100, 101, 102.....
(I do not want to use append query with autonumber field.)
Excel 009
Create a Temp table with 2 fields
1) AutoNumber
2) Keyvalue
Use a append query to fill the temp table's [KeyValue] with the primary key
value of you data table.
Run an update query using the AutoNumber to fill the ID field
([AutoNumber]-1) + 100.