How to access date from Oracle Databace to Excel

  • Thread starter Thread starter David Willis
  • Start date Start date
D

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
 
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
 
Back
Top