Note: In Access 2000, when you click and drag to create the command button, a wizard pops up; you should cancel out of that and proceed to the next step, right-click the button, and select Properties.

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.