I am importing an Excel Workbook into a table by usng the following piece of code:
How would I modify this so it also created an auto number field which was the primary key?
Code:
DoCmd.TransferSpreadsheet acImport, 8, "tblCalls", "C:\Documents and Settings\David\My Documents\Phone Bill Checker\Calls" & s & ".xls", True, ""How would I modify this so it also created an auto number field which was the primary key?
