Unanswered: exporting multiple excel file then append to MS Access tables
Does anybody with this one. I have 3 different tables in MS access (table1, table2,table3) that contain different data. Data are coming from Ms Excel (xl1.xls, xl2.xls, xl3.xls).
How can I possibly do openfile and then can select one time all the 3 excel file I have and then can append it automatically to access table :table1 for xl1.lxs , table2 for xl2.xls and table3 for xl3.xls.