While Access 2003 and 2002 include a wizard for importing data from an Excel file into an Access table, you may want to create a command button that will perform all of the steps of the wizard for ...

Click to activate the Control Wizards button, if necessary, and then click the Command button tool. (In Word 2007, on the Form Design Tools tab, ... Excel, and Access tips, ...