| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to access MSSQL table in a user defined function
Hi
I would appreciate if someone could help me with some sample code that I can use in my custom function to access a ODBC database and send a SQL statement to retrieve data from a table. BTW, how can I store the ADO recordset in a array so that my VBA function can manipulate? Your advice most appreciated. Thanks Best Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User defined function | New Users to Excel | |||
| Access connection works in Macro, not in user-defined Function | Excel Programming | |||
| User defined function | Excel Programming | |||
| User-defined data type; Error: Only User-defined types... | Excel Programming | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
Threaded Mode
