you can not use the ADO control, as you have noticed.

this is out of my league, but it seems like you'll need to use QueryTables on the Mac OS. Look that up in Excel 2004 help. I'm not on my mac at the moment. You could also try connecting without VBA first, using the database query...get external data under the data menu, I think.

I'm afraid that's the best I can offer. If you run into specific problems with using querytables, try posting in the regular Excel help forum, as that is in windows and mac OS's. forget trying to use the activex though.