Recent content by gcgc2000
-
G
import excel different file everyday
Hi David, I am also looking to accomplish the same what you described below. I am very new to VBA/Access. Could you please provide a sample code if possible. Regards GCGC- gcgc2000
- Post #4
- Forum: Visual Basic
-
G
appending table in access from excel, excel file name change everyday with date
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...