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
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).