Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    10

    Talking Unanswered: How to generate a sequence ?

    Hi,

    I need to create a new table, add 4500 records from an Excel spreadsheet to it. In addition to fields from the spreadsheet, I need to add a primary key - a new field whose value needs to be autogenerated and autoincremented starting from a fixed number - say 100345001.

    so the first record shud have key = 100345001
    the second record shud have key = 100345002
    ..........
    ..........
    and so on and so forth.

    HOW DO I GO ABOUT generating such a sequence in Access ?

    Thanks,
    GK

  2. #2
    Join Date
    Apr 2002
    Posts
    139
    Remember this question was handled at the Access Web.
    Have a look at
    http://www.mvps.org/access/tables/tbl0005.htm

  3. #3
    Join Date
    May 2002
    Posts
    10
    Thanks much, MARION!! Works! :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •