Microsoft: Query X for Mac

It's about friggin' time. A couple weeks ago I wanted to connect to a database using ODBC (which is an advertised feature of Excel v.X) and dump the info to a spreadsheet. It kept telling me I needed Query X... but it didn't exist! The only way you could use ODBC data was if you created the query range using Excel on Windows and moved the spreadsheet to the Mac... the Mac could refresh the data but not change the query.