Hello again forum,

I have several spreadsheets for each month of this year and for last year. I asked a while ago about this for just my current year files and someone mentioned running a Union Query. It worked, but now that I am trying to incorporate last year's files as well, when it runs, Access locks up and is non-responsive. The rare occasions that it runs, I also need to create a simple query of the union query, because I need this information to be used in an Excel pivot table, and Excel won't allow me to use union queries as my external data source. I used to run the Simple Query Wizard, but now choosing that locks up Access as well.

I assume it is because I have so many files, but I would like to get your feedback on a good way to get a query of all my files, so that I may use it as my external data source for a pivot table in Excel.

Many thanks for the help!

-Keith