If you have users who prefer to push Excel data into Outlook instead of importing it from inside Outlook, try this VBA event procedure.

Using SQL statements in Excel enables you to connect to an external data source, parse field or table contents and import data – all without having to input the data manually.

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.