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
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
Visit the new-look IDUG Website , register to gain access to the excellent content.