PDA

View Full Version : How to create connection ?


malvin10
08-06-03, 00:48
How do i create a ODBC connection to Oracle DB ? Steps needed to do this ? Many thanks to those willing to help :)

sathyaram_s
08-06-03, 07:07
Mean from Excel ?

Open a new worksheet and click on the 'Data' menu in the tool bar ... Select 'Get External Data ' and 'New Database Query' ... Select your Oracle Database as your datasource and build the query you desire ... Save it ... the next time you run the query, you will be connected to the Oracle Database


HTH

Sathyaram

Originally posted by malvin10
How do i create a ODBC connection to Oracle DB ? Steps needed to do this ? Many thanks to those willing to help :)