Hi!
I am newbie here. Sorry if I post at the wrong thread.
I have a database with multi-table namely (with many fields in each table);
Table 1: Personal Details_tbl
Table 2: Assets_tbl
Table 3: Liabilities_tbl
And I have excel.xls file with multi-sheet namely;
Sheet 1: Personal_Details_tbl
Sheet 2: Assets_tbl
Sheet 3: Liabilities_tbl
How do I import data from excel.xls file and overwrite/ update data in access table by using command button. Perhaps, I can put vba codes when I click the command button. Thank you all!