Question: how to import data from excel to access automatically?
Answer: The location of the import/link wizard differs slightly depending upon your version of Access. ...  In the Get External Data - Excel Spreadsheet dialog box, in the File name box, specify the name of the Excel source file. Select Link to the data source by creating a linked table, and then click OK.