Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADODB.RecordSet
Hi. I can't seem to find a good page defining all the methods available to
the ADODB RecordSet and how to use them. So, i'm working blind (as a newbie without much VBA experience). I'm using Excel 2003, and an ADO connection to an Oracle Database. I tried this bit of code (with sSql as a previously defined SQL string, and ActDB as a previously opened Database connection): Dim recSet As ADODB.Recordset Set recSet = New ADODB.Recordset recSet.Execute (sSql, ActDB) For i = 1 To iterator Application.Worksheets("HOTPortfolio").Cells(j, 1) = recSet(i) Next i but i get an error that the line "recSet.Execute(sSql,ActDB)" is expecting an = What am I doing wrong? Can anyone point me in the direction of a good set of definitions? (preferably in the style of the online Java Library) Thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete ADODB Recordset | Excel Programming | |||
ADODB Recordset problem | Excel Programming | |||
0 with ADODB Recordset | Excel Programming | |||
adodb.recordset with excel | Excel Programming | |||
ADODB Recordset | Excel Programming |