How to populate sequential numbers in a field using SQL or VBA?

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

.

Relevant Pages

  • RE: Excel/SQL Automation help
    ... am execting an SQL statement which counts 1&2 and groups by email address. ... comparison before yo move the e-mail to the new sheet to check if it has ... You can run your macro from Outlook VBA, Access VBA, or Excel VBA. ...
    (microsoft.public.excel.programming)
  • Re: Exporting/Editing Risks
    ... I do have a basic SQL and VBA knowledge; however, ... > 2) Create a view in the Project database that shows all risks and includes ... > 3) in any version of Excel read the view into a sheet. ...
    (microsoft.public.project)
  • RE: Excel/SQL Automation help
    ... am execting an SQL statement which counts 1&2 and groups by email address. ... comparison before yo move the e-mail to the new sheet to check if it has ... You can run your macro from Outlook VBA, Access VBA, or Excel VBA. ...
    (microsoft.public.excel.programming)
  • RE: Excel/SQL Automation help
    ... comparison before yo move the e-mail to the new sheet to check if it has ... You can run your macro from Outlook VBA, Access VBA, or Excel VBA. ... Basically at the moment I have an SQL table with data relating to email ...
    (microsoft.public.excel.programming)
  • Re: Use MS Query in VBA to only get a SQL statement
    ... Excel macro keeps running while the query grid is showing, ... how you would capture the sql. ... > Access database under VBA control, where you could bring up a new ...
    (microsoft.public.excel.programming)