Re: Access and Oracle

Ed Prochak wrote in message <7dbd0n$k9g$1_at_nnrp1.dejanews.com>...
>In article <oLQJ2.7649$R92.4346_at_news20.bellglobal.com>,
> "Firestarter" <cheryl.jeff_at_sympatico.ca> wrote:
>> Being somewhat new to both these databases I'd thought I'd ask some
experts.
>>
>[snip]
>>
>> These are some the questions:
>>
>> 1) What's the easiest way to retrieve and input the incoming Oracle
>> information. The smaller business is not
>> connected to the Internet 24/7.
>
>ORACLE has SQL*Loader for putting data into the database from a file
(usually
>text format). I'm sure Access has similar feature. You may have to use VB
>to automate it, but it is essentially similar.
>

We use FORMS4.5 and connect via ODBC to Access, read in the records, then connect to Oracle and insert/update records in Oracle tables as required. FORMS4.5 allows you to connect to one database at a time but does allow you to code very complex procedures using PL SQL to get the job done.

The other option besides SQL*Loader is the UTB command available as part of the Oracle Open Client Adapter for ODBC as part of Developer2000. Received on Fri Mar 26 1999 - 08:27:13 CST