I have a consolidation task to be done.
I have uploaded my example spreadsheet to the below link
My spreadsheet sheet will be in the same format but with 5 more worksheets and each worksheet consisting of more than 200 rows. Think this is a input spreadsheet to 300 customers and they fill in the details and send it back as an attachment to a common email Id.
My task is to consolidate all the attachments. Its not possible to do it directly into an excel sheet as the columns exceed 1000 and the rows exceed 10,000.
I thought I will extract the data from each attachment into a MS Access Database and then query the Database for the required information.
Do you think this is the right way of doing it or is there any other way.
I suppose I can extract the data from each attachment with VBA code. I tried importing data from excel to MSAccess and it was not satisfactory.
Please let me know if I am approaching the right way and any material which helps me to work with this task