Move data from Access to Oracle periodically and automatically

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Fri, 02 May 2003 12:41:48 -0800
Message-ID: <F001.0058E680.20030502124148@fatcity.com>

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
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 925-7187
stephane.paquette_at_standardlife.ca <mailto:stephane.paquette_at_standardlife.ca>

--

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

Author: Stephane Paquette
  INET: stephane.paquette_at_standardlife.ca

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 - 15:41:48 CDT