How to Import an Excel Spreadsheet Into Access With a Macro. If you ever wanted to click a magic button and make complex business tasks happen automatically, macros can make that wish come true.

Give the file a name and click Save. To import the form into another application, follow these steps: Open the workbook that contains the code for your new application. Press [Alt] [F11].