Asher David
01-15-07, 13:40
| Hi, 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. I want to do the code in VBA access. thanks! |