gopi09_m
11-25-2008, 09:21 PM
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
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