Question: how to import excel data into access table with command button?
Answer: Open a new form in Design view., Click the Command Button tool in the Toolbox., Click and drag in the form where you want the tool., Click Cancel to close the Command Button wizard if necessary., Right-click the Command button and select Properties., Click the Event tab and click the On-Click property box.