Update a table and add id number incrementally?
Posted on 2009-05-05
I have a spreadsheet with data that I need to write its contents to a sql server table. And when I write the records from the spreadsheet to the table, I need to start the id field with the number 2147 and increment by 1, for the remainder of the records.
Also, I am using CF 5.0
What is the best process/approach to do this.
Please provide a simple example if possible.