Question: how to import multiple excel files into access using vba?
Answer: Switch to the "External Data" tab in Access and locate the "Import & Link" group. ... 
Click on the "Browse" button and use the "File Open" dialog box to locate the first Excel file you want to import. ... 
Select the first radio button in the set of three choices to set how the Excel data will be used.