View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
camienu camienu is offline
external usenet poster
 
Posts: 1
Default 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.