Connect to Oracle DataBase

[gopi09_m]

Hi,

How do i connect to DataBase in Excel VBA.I have the following details about the DSN and DataBase Table..

ConnectionString= "DSN=OracleDSN;UID=OrUser1;PWD=****"
DataBase Table = Emp

I want to execute the query "Select * from Emp" and retrieve all the values of
Emp table..

Thanks
Krrishna

[shamsam1]

check this out

http://www.connectionstrings.com/?carrier=oracle

[Bob Phillips]

Here is my suggestion http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForOracleFromOracle

[gopi09_m]

thanks for that.