Processing Data From More Than 300 Workbooks

I have more than 500 list of workbooks, each workbooks having data filled with 25000 Rows and 15 Columns.

I want to filter and summarize the entire data to know different parameters of the data for example a filter by different States, A subtotal of different states that might tell me:
CA: 40000
NV: 86222
FL: 63525

Is it possible through MS Access? Or Through SQL? (Does Access and SQL have an option to import multiple workbooks at a time?)
or through VBA? or Applying Formula by giving references from closed workbooks?


Any advice will be very helpful!

Regards,
Faiz

You can import your worksheets into Access. It can be done singly or if you wish to import multiple worksheets, you will require VBA to do so. As each sheet is imported, you will need to append each sheet to a single table. You will need to make sure that each sheet you import is normalized and is set up exactly the same, ie. Same field names in the same order. You can then run an aggregate query to summarize all the data.