Maybe this will help?
w w w .accessmvp.com/KDSnell/EXCEL_Import.htm#ImpAllWktsSepTbl
Or this?
I now use a very simple method with a file named "Export.xls" (for import use)
I have "docked*" each tab as an table in the access database and use "insert into"querys to read each tab out of the...