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.

Select the data source you want to import from (e.g., SQL Server, Access, Excel, etc.). Follow the prompts to connect to your data source and import the data into PowerPivot.