Union with ADO

[Glory]

I just read this page, which indicates a good way to make two full worksheets work with one pivot table is to Union the two worksheets with SQL and then treat the SQL query as the data source.

Can this be done with ADO as well?

I have no experience with either, can somebody help me get started?

 

[Ruddles]

SQL has a UNION operator, if that's what you mean.

What exactly are you trying to do?

 

[Glory]

The place I work at uses pivot tables to check data. I want to make it work better.

I want to make all their data verification sheets print simultaneously. The best way to do that would be if all three kinds of information could be accessed from three pivot tables.

The only alternative is to create six new sheets whenever the data crosses 65k rows, 3 with new tables, and force the userform I'm building to working with the new tables.

It takes like thirty seconds to create each new table on these machines; too long, way too long. They will never accept this model.

Can you maybe just help me start with unioning source ranges on multiple sheets using ADO/SQL?

A skeleton, an outline, that's all I need to get going. I don't even know where to begin.