Question: how to import excel data in access database?
Answer: In the Get External Data - Excel Spreadsheet dialog box, in the File name box, specify the name of the Excel file that contains the data that you want to import. Click Browse and use the File Open dialog box to locate the file that you want to import. Specify how you want to store the imported data.