Please refer to the attached report Book2.zip.
There will be up to 365 files each created on daily basis now I want to create a database that automatically creates summary for me i.e. imports the data, on as it is, in one table with from where I can create different reports i.e monthly production, wastes, operator/supervisor performance analyses in access.