Import unique ID

vaughan198

Registered User.
Local time
Today, 08:10
Joined
Nov 16, 2011
Messages
40
Hi there I am using a simple code to append three excel worksheets (in the same workbook) to three tables in my database. There are multiple records per table/per import.
Is there any way to apply a unique ID to all the records in each import. I.e all the records I import today have an Import ID of 1 and all the records I import tomorrow have an import ID of 2. This is so that I can do statistical analysis between different report imports.
Thanks,
Will
 

Users who are viewing this thread

Back
Top Bottom