How to access date from Oracle Databace to Excel
 

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

How to access date from Oracle Databace to Excel
 

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