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.