RE: Move data from Access to Oracle periodically and automatically

Roy's suggestion should work just fine. In addition you might consider Oracle Lite which is aimed at exactly this sort of need.

Niall

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of
> Stephane Paquette
> Sent: 02 May 2003 21:42
> To: Multiple recipients of list ORACLE-L
> Subject: Move data from Access to Oracle periodically and
> automatically
>
>
> 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: Niall Litchfield
  INET: niall.litchfield_at_dial.pipex.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).