How to access date from Oracle Databace to Excel

[David Willis]

Dear All,

I am trying to access/connect oracle database to insert and select data
from
tables. I don't know what to use like ADO? ADOX? ADODB? or others?

I was trying to connect using the following code:

Dim db As ADODB.Connection
Set db = New ADODB.Connection
db.ConnectionString = "Data Source='cis2';" & _
"User ID='cis2view';Password='viewcis2@hkdb';"
db.Open
db.ConnectionTimeout = 30


db.Close
Set db = Nothing


From Data Source which mean I need to setup a Name from ODBC call Cis2
right?

Does anyone have any idea what is the code look like and how to write it?

Thanks for your helf

David

[NickHK]

David,
Easiest way (for me) to create/test connection strings.
Create a text file somewhere suitable, called "Whatever.udl". Double click
it. Follow the steps. Close.
Open in a text editor and examine the connection string.

NickHK

"David Willis" <davidgwillis@hotmail.com> wrote in message
news:2675f1db9e5991d22ecb3baf423e1dda$1@www.dotxls.com...
> Dear All,
>
> I am trying to access/connect oracle database to insert and select data
> from
> tables. I don't know what to use like ADO? ADOX? ADODB? or others?
>
> I was trying to connect using the following code:
>
> Dim db As ADODB.Connection
> Set db = New ADODB.Connection
> db.ConnectionString = "Data Source='cis2';" & _
> "User ID='cis2view';Password='viewcis2@hkdb';"
> db.Open
> db.ConnectionTimeout = 30
>
>
> db.Close
> Set db = Nothing
>
>
> From Data Source which mean I need to setup a Name from ODBC call Cis2
> right?
>
> Does anyone have any idea what is the code look like and how to write it?
>
> Thanks for your helf
>
> David
>
>