In Microsoft's infinite wisdom (and monopoly), it does not include ODBC drivers for Excel for the Mac. There are some available, but you have to pay for them!!

Here is a link for OS X ODBC drivers ($29.95)

http://www.actualtechnologies.com/