Re: Loading data from Access to Oracle?

Varad Acharya wrote:

> Here's one way to do it.(MS-Access 2.0)
>
> Launch Access.
> Open desired database.
> From the File menu choose Export
> Choose SQL Database from Data destination list
> Choose desired table
> Specify table name for ORACLE (case sensitive)
> Choose Oracle database to load to (assuming you have an ODBC connection
> to the ORACLE db)
> Login to ORACLE
>
> and that's it.

thanks, though my original question was... how do you do it from the Oracle(Unix) end? i am looking to do this process on a daily automated basis to populate an Oracle Warehouse.
it seems to me Access has to create the export file rather than Oracle reading the *.mdb, or Unix creaitng the export file from *.mdb i am ignorant of Access (and would like to keep it that way), but i am not into all this manual running of downloads.

steve. Received on Mon May 19 1997 - 00:00:00 CEST