Forum Discussion
maximajayaa
Jul 20, 2021Copper Contributor
Can Access import excel files in a folder just like Excel's power query?
Hey, I am new with access and I used to use Excel for my business needs. However, I am currently trying to use Access. So far, I am looking for a way to import excel files in a folder which can be re...
isladogs
Jul 20, 2021MVP
If the Excel file names stay the same, then why not just LINK to the Excel files instead of importing them.
By doing that, you will always have the latest Excel files available in Access
By doing that, you will always have the latest Excel files available in Access