Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ODBC database access
I would like to query the Oracle database using ODBC on an Excel
spreadsheet, and put the result in a recordset. However, when I compose the program in the VB, it didn't recognise the Database and Recordset datatype. I found many solutions on the web that would use the Database and Recordset types. I also found that there were many other examples that used the ODBC functions like SQLBind, SQLExecQuery, SQLOpen and SQLRetrieve, etc. I am using Excel 2002 with Visual Basic 6.0 as Visual Basic Editor. Would you please kindly tell me if there is any components that I have to install before using the functions? And would you please kindly show me the way for retrieving the data in a recordset from Oracle database? Thank you very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel connection to ODBC database | Excel Discussion (Misc queries) | |||
ODBC database query | Excel Discussion (Misc queries) | |||
ODBC Drivers to a SQL database | Excel Discussion (Misc queries) | |||
how can I create a ODBC database in excel | Excel Worksheet Functions | |||
Connect to Oracle Database through ODBC with VBA | Excel Programming |