Append to Oracle

[sharon]

Hello!
I have an application in A2K2.
My client has anothe application created in Oracle..He
wants me to create an interface so that selected Data in
my application is appended to the tables in Oracle.
How do i begin to do it?
TIA
Sharon

 

[Eddie W. Stroud]

Probably the easiest way is to install the Oracle client on your machine
that has Access. A part of the install is that it installs the ODBC driver
for Oracle. Link to the table via ODBC and append as you would any other
table.

Note that you will need to have a user ID and the proper permissions set up
in Oracle first.

There may be various other considerations regarding data types, etc. but
this is how I would begin.

Actually, using Access as a front end to a back end Oracle database works
pretty well.

Ed