Hi Bob, I don't know if its possible to do it by those means, but it is definitely possible, using "heterogeneous services" to have Oracle pull the data from Access over a database link. You could schedule that through the Oracle scheduler, or have MS scheduler execute a sql script.
HTH. Beth -----Original Message----- Sent: Thursday, June 05, 2003 5:30 PM To: Multiple recipients of list ORACLE-L Gurus, We would like to load data from MS Access 97 database to Oracle 8.1.7 database with MS scheduler? Is it feasible? It could be done in MS SQL server with the helps of DTS package. Please share your experience in this regard and let me know what could be the best method to automate loading data from MS Access 97 to Oracle 8.1.7. Thank, Bob __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).