| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible write a self-defined function in excel that connect to SQL server to get data?
I have tried to write ADODB connection in VBA Editor...
but it seems that it can recognize those key work in ADODB... Any good reference / link about this suggest? thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is it possible write a self-defined function in excel that connect to SQL server to get data?
in the VBE you need to go to Tools=References and select the appropriate
ADO library that defines ADODB. -- Regards, Tom Ogilvy "tc" wrote in message ... I have tried to write ADODB connection in VBA Editor... but it seems that it can recognize those key work in ADODB... Any good reference / link about this suggest? thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to connect the Excel 2007 in SQL Server 2005? | Excel Worksheet Functions | |||
| Connect to OPC / DDE server | Excel Worksheet Functions | |||
| i want to connect excel with sql server 2000 as database with macr | Excel Discussion (Misc queries) | |||
| connect to an oracle server | Excel Programming | |||
Linear Mode
