Re: Reading an Access .mdb from Oracle

You could export the access data to Oracle over ODBC making sure ( for convenience when manipulating it in SqlPlus) to use ALL CAPS for table and field names..Use the resultant Oracle table to update the other one....  

Ed Stevens <Ed.Stevens_at_nmm.nissan-usa.com> wrote:

>One of our developer's just presented me with an interesting question.
>An end user has loaded a bunch of data into an Access table, and now we
>need to update one of our Oracle tables with that info. The developer
>wants to know if an Oracle procedure can read the Access table.
>
>I told her that I wasn't aware of a way to do it entirely in Oracle,
>tht the best bet would probably be to write a VB pgm that could read
>the Access table directly, and connect to the Oracle table via an ODBC
>connection - perhaps even defining a linked table within the Access
>database.
>
>Other solutions?
  Received on Tue Aug 22 2000 - 16:01:45 CDT