Question: how to import an excel spreadsheet into access with a macro?
Answer: Launch Access and open one of your databases.
Move to the Tables pane and double-click the table you wish to load. ... 
Launch Excel and open the spreadsheet you wish to load into Access. ... 
Return to Access and click “Create.” Double-click the “Macro” button on the Ribbon to view the Macro Builder.