Hi There,
I am very new to access and have learnt all by myself so far. I want to automate import from excel and append in to my table in access.
What I am trying to do:
1.I have excel file automatically saved as yesterday's date in YYYYMMDD.xlsm
2. in this Excel file, I want to import data from...