RE: MS Access 97 to Oracle 8.1.7 Scheduler

From: Pardee, Roy E <roy.e.pardee_at_lmco.com>
Date: Mon, 09 Jun 2003 10:25:26 -0700
Message-ID: <F001.005ADBA4.20030609100441@fatcity.com>

You can specify the name of a macro for msaccess to run on startup w/the /x parameter of the msaccess executable. That macro can do a RunCode action to run a VBA procedure that you specify (which is where you can do your data loading) followed by an Exit action to shut down msaccess. IIRC, you can schedule a command like:

"c:\program files\microsoft office\office\1033\msaccess.exe" <<path to the msaccess db file>> /x macLoadDataIntoOracle

Alternatively, you can write a windows scripting host script that will build that command line up for you (after e.g., verifying that the db file & msaccess executable are present, maybe doing some logging, etc.) and then schedule that.

HTH,
-Roy

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487

-----Original Message-----

Sent: Thursday, June 05, 2003 2: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: Pardee, Roy E
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