MS-Access -- "Saved Import" procedure
Posted on 2014-11-25
We're currently conducting a survey (where users will return a standardized spreadsheet).
For importing purposes, I've created an import procedure ("External" tab | "Saved imports") that will facilitate importing the spreadsheet data into a database.
At this time, the saved procedure/operation points at the designated file path and -- once it finds the designated filename -- will successfully import the data.
Here's the challenge: In order for the MS-Access procedure to work, the filename must be identical. For example, the procedure refers to file path: H:\...\...\...\Survey.xlsm
As you can imagine, this will require to import each spreadsheet one after the other (while also ensuring to rename the XLS from whatever filename a user may have chosen to "Survey.xlsm".
I tried to change the procedure's file path to: H:\...\...\...\*.xlsm
... unfortunately, that doesn't work.
Thus, how can I run an Access procedure and import dozens/hundreds of XLS spreadsheet at once without having to rename each XLS to "Survey.xlsm"?