SQL import to Excel using VBA for PC and MAC
 

Let me start off by saying I am new to EXCEL 2003 and VBA programming. Here
is what I need to do. If a user enter's a code in cell A1, it needs to
connect to a SQL database (SQL 2000) and retrieve/import the records from the
table for that code and insert it into a worksheet. The problem is that I
need it to be able to run on either a PC or a MAC. There is code to use
ADODB or ODBC for a PC but have no idea how to get it to run for a MAC.

Any help would be appreciated.