Oracle-L: RE: Move data from Access to Oracle periodically and automaticall

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Fri, 02 May 2003 13:01:51 -0800
Message-ID: <F001.0058E6DF.20030502130151@fatcity.com>

Or use a scheduler for Windohs that can run an MS Axxess macro to push the MS Axxess data to a "holding area" in the Oracle DB via your ODBC connection. This holding area could then be monitored periodically by a DBMS_JOB, for example, to see if there's data in it. If there is, it moves it to the "live" table(s), audits it, etc.

Just a knee-jerk thought...

Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_qtiworld.com           Quad/Tech International, Sussex, WI USA

-----Original Message-----
Sent: Friday, May 02, 2003 3:42 PM
To: Multiple recipients of list ORACLE-L

Hi,

We're thinking to a new system.
With this system, 30 users will entered data on their laptop in an Access database.
Once per day, they will upload the data to an Oracle database (oracle 8172/aix).

I've used heterogeneous services to read a Sql Server DB using Merant ODBC driver but it seems I need Oracle Transparent Gateway to access Access.

Any info ion this ?

Thanks

Stephane Paquette
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com

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: ListGuru_at_fatcity.com (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). Received on Fri May 02 2003 - 16:01:51 CDT