How do I import two range files from Excel to Access database
I have an excel workbook called mydata.xlsx. The workbook has to tabs (tab "A" and "B"). In each tab I have a name range (name manager) that I want to import into my access database table called tblAmount. The first name range name is Import1 and the second name range is Import2. How do I import these with code into my table tblAmount?