We have a proprietary inventory program that archives data weekly into separate .mdb files, all contained in a single directory.
We'd like to have this data available in a single access (or MySQL) database for querying from Excel so that we can create reports.
Is there a way, preferably automatically and completely automated, to accomplish this? As of right now we need to manually import the new access database weekly.
The tables and structure are always the same, and there is never repeating data.