I am looking for a way to copy data from an excel spreadsheet to a temp table in access 2003 and if it imports correctly to append the data to the main table. The spreadsheet importtemp table and finalimport table will all have the same field names. The finalimport table will have data inputting to this table from multiple parts of the database and there is an auto generated key for each new line.
I believe I can import the code using the code example below to the temp table. But how can I copy the code from the importtemp table to finalimport table. The fields will be the same and in the same order. I think I can use the append command but I am not sure how to do it with the auto generated key in the finalimport table.
This is all in access 2000 excel 9. I prefer to is vba as apposed to sql but whatever works. Initially I thought to input it into the finalimport table but importing external data into the final table didn't seem right.
FileName:=CurrentProject.Path & "\customer.Xls", _
Snippet from "Mastering Microsoft Office Access 2003" by Alison Balter c2004 Sams Publishing