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 ?