Hi All,

I have a consolidation task to be done.

I have attached an example spreadsheet

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

I dont see any "Attach" button to attach my files in this forum, can you please let me know if its possible to do so.
Thanks in dadvance.

You can email the attachment to interested posters.

You can import this data, but you will want to make sure that the Excel spreadsheet is properly formatted for import. You can also link directly to them.

I hate to make a reference to it, but O'Reilly has a good book on Integrating Excel and Access that might help.

HTH


mmcdonal