Is it possible to save my query criteria to apply to new data source / connection

Hi,

I have a huge csv database split across about 8 files (due to file size). To extract the data I need I run queries in excel and edit the query (involves filtering, splitting rows, changing number formats etc.). So this means doing this 8 times for each csv file (the criteria are the same for each one).

Currently I've saved the query editor formulas I need in a word doc and copy and paste them in but I was wondering if it's possible to save the query critieria so that I can load them up when I load the next csv file?

E.g. I'd do one sheet, then load a new connection to the next sheet and then somehow just apply / load my saved query to apply to the newly loaded sheet?

Hi Neil, thanks for the quick response. I've had a little exposure to Access but have a vague recollection that there's some problem about 2GB limit for Access (I've got 8x 8GB files).

So are you suggesting I could combine into one master CSV file (that would be say 64GB) and then run query in Access to extract the data (the data I need probably would be under 2gb when filtered so that could work if I understand correctly?

The problem then is that I then need to use a pivot table to filter that data into the format I need (which ultimately does boil it down to around 40,000 lines of data) and have also split the csv files because trying to run query and import to excel goes well over the rows Excel can handle (even using 64 bit version).

Sorry a bit jumbled there maybe so hope that makes sense?