DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, _
"MSysTEMP", "C:\Users\ads\Desktop\" & iName
I have the above code to append an excel file to database.
Problem is, this is something I used in prior database and basic.
In the current database, my first field is called 'IDNUMBER'
When appending manually, I have to
- Change the type of this IDNUMBER field to 'text' (from double)
- Assign IDNUMBER as primary key.
Rest remains the same.
How do I incorporate the above 2 in the append query above?
Thanks for the help!