Thanks for the quick reply.
You know I'm not sure why I'm using ADO to be honest. In the past when I needed to clean up data exported from my system I would put each table into it's own worksheet and then use Microsoft Query to create the joins and extract the data to a new workbook so it can be used for Pivot Tables and charts. From what I've read I should no longer be using Microsoft Query and instead use ADO.... That's the only reason why I'm looking at doing this. I'm completely open to other ways of doing this but I probably will need a little direction.

XLD - Can you give me a little more detail or point me in the right direction on what I should research?

Thanks,
-J