I am new to this forum and not sure this is the right place to ask this but I'll try anyway.
what I'm wondering is if access is able to accomplish the following tasks or if there is a better route.
I'm looking to process multiple excel files and run simple equations on the resulting data. I will be getting the same data layout in all the excel documents.
I would like to create a database of the excel documents that can easily be sorted and the reports with the processed data from the documents can printed.
example spreadsheet a - customer name / results from test a / result from test b/ result from test c and so on....
spreadsheet b - customer name / results from test a............
i want to be able to sort through the customers and process run the test results thru some equations.
the test results are actually numbers that come from a testing lab and they send the results back in a spreadsheet format in excel.
Any recommendations or ideas for this would be greatly appreciated I've used access in the past but its been a while.
thanks.