Have you run that query directly on the database? I don't do Oracle, but
wouldn't think you need to define deal in the from, but join into it.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Dan Thorman" wrote in message
...
sSql = "select property.property_name " & vbCrLf
sSql = sSql & "from property, deal " & vbCrLf
sSql = sSql & "where deal.prop_id = property.prop_id and " & vbCrLf
sSql = sSql & "deal.deal_status_id = 9 and " & vbCrLf
sSql = sSql & "deal.accnt_id = " & accountID & vbCrLf
sSql = sSql & "order by property.property_name"

"Bob Phillips" wrote:

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!!