RE: Move data from Access to Oracle periodically and automaticall y

From: Pardee, Roy E <roy.e.pardee_at_lmco.com>
Date: Fri, 02 May 2003 13:36:49 -0800
Message-ID: <F001.0058E7D4.20030502133649@fatcity.com>

You could use ODBC to push the data from msaccess to oracle--just link the ora tables & do msaccess 'append' queries.

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-----Original Message-----
Sent: Friday, May 02, 2003 1: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
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).
--

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

Author: Pardee, Roy E
  INET: roy.e.pardee_at_lmco.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:36:49 CDT