The VBA to import data in 12 excel worksheets to 12 access tables of the same fields
The VBA to import data in 12 excel worksheets to 12 access tables of the same fields
save the file to a generic file: c:\temp\File2Import.xls
Link the 12 sheets as external tables from the same file c:\temp\File2Import.xls
build 12 append queries to import the 12 tables to the target table.
put all queries into a macro.
steps are then:
1. overwrite the c:\temp\File2Import.xls with the new file,
2. run macro
done.
Thank you for reply.
My question is how can the import from excel automate with vba code.
See Ken Snell's site at http://www.accessmvp.com/kdsnell/EXCEL_MainPage.htm