Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Claremont, CA
    Posts
    38

    Unanswered: Use Excel to access Oracle DB

    Can Excel be used to access and make queries into an Oracle database?
    We sometimes use MS Access to do this but prefer to do it in Excel, if possible, as all our users have Excel. Thank you.

  2. #2
    Join Date
    Feb 2004
    Posts
    533
    It's easiest to use ODBC driver which somes with MS Query. Select "New Database Query..." From "Data->Get External Data..." Menu. Select New Database option then follow the wizard to select driver and define source. After defined you can attach it to the workbook and set options to update on open, remember password. etc.


    /*
    ~

    Bill

Posting Permissions

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