I have a folder which currently has 96 sub-folders. Each working-day another sub-folder is added to this folder. The sub-folder all have the working-date (the folders creation date) as their name with YYMMDD as format (f.i. 170103 for Jan, 3rd 2017).
Each sub-folder contains 6 (different) Excel workbooks and they all have different names. However, the names for the workbooks stay the same in each sub-folder (so only the folder name changes each working-day).
Each of the 6 Excel workbooks has one sheet with data. The data structure of the sheets do not change but since each workbook table has a different data structure the 6 different workbooks have to be imported to different MS Access tables.
When doing the import each data-record needs to get the date of the folder minus one working day) as an additional data point.
I would like to import all the Excel workbook in one batch and then periodically (f.i. daily or weekly) import the additional Excel workbooks which have been created and are not yet imported.
Please let me know if you need more information about this task and your help would be highly appreciated.
Thank you very much in advance!
Each sub-folder contains 6 (different) Excel workbooks and they all have different names. However, the names for the workbooks stay the same in each sub-folder (so only the folder name changes each working-day).
Each of the 6 Excel workbooks has one sheet with data. The data structure of the sheets do not change but since each workbook table has a different data structure the 6 different workbooks have to be imported to different MS Access tables.
When doing the import each data-record needs to get the date of the folder minus one working day) as an additional data point.
I would like to import all the Excel workbook in one batch and then periodically (f.i. daily or weekly) import the additional Excel workbooks which have been created and are not yet imported.
Please let me know if you need more information about this task and your help would be highly appreciated.
Thank you very much in advance!