| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import XML data...Is there a size limit on the import? | Excel Discussion (Misc queries) | |||
| How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
| Import Macro in PERSONAL.XLS will not import to my main document | Excel Programming | |||
| Data Import to Excel Issue with Excel 2007 and Excel 2003 on same | Excel Discussion (Misc queries) | |||
| Import modules EXCEL caused an invalid page fault in EXCEL.EXE | Excel Programming | |||
Threaded Mode
