Sounds like the SQL is the problem. What is in sSql?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Dan Thorman" wrote in message
...
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!!