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

    Thumbs up Unanswered: Script to create connection, query Db and export from Oracle to Access

    Hi,

    Is it possible to write and run a script to make a connection to the oracle DB, run a query to get the query results and then extract the results into MS Access? in other words, a script that does just abt everything for you. Any sample codes or websites having these codes will be much appreciated. Many Thanks to those willing to help

  2. #2
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188
    if i understand you correctly, the script would be something separated from both ora and access. something like run_my_script.exe... that you can just double click. its possible with a simple vb program but may take some time and effort to write.

    less hard way is to link tables from access to ora db and do all the query you need within access.

    hope this helps
    qha_vn

Posting Permissions

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