hi
i am trying to connect to an oracle database do a query
and return the results to a worksheet
i know that i can record a macro and do it that way but i
am tring to do it myself
here is what i have so far

Dim sConn As String
Dim sSql As String

sConn = "ODBC;DSN=DAN;uid=ear;pwd=ear;"
Set rsb = sConn.OpenRecordset(sSql)
sSql = "SELECT * "
sSql = sSql & "FROM ear_form_s"


havent got a clue where to go form here
hope someone can help

andy