PDA

View Full Version : Script to create connection, query Db and export from Oracle to Access


malvin10
08-06-03, 00:52
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

qha_vn
08-14-03, 01:45
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