Well it doesn't seem like I'm going to get ADODB working in Excel, so I'm looking for other solutions.

MSQuery *does* work, as do other tools using ODBC. So (realizing this is really an Excel question) does anyone have some advice for using any of Excel's other data tools? I've never used them before.

All I really need to do is have all of the queries (there's a dozen or so) update when the book is opened, and then run some code on the data when the updates are complete.