Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Singapore
    Posts
    15

    Unanswered: How to create connection ?

    How do i create a ODBC connection to Oracle DB ? Steps needed to do this ? Many thanks to those willing to help

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: How to create connection ?

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •