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.