Re: Reading an Access .mdb from Oracle

You can do it in Access, after setting up Oracle as an ODBC server. I did something like this once: Selecting out of a MS SQL Server database and inserting into a Foxpro database. The query looked like a normal select from one table into another. I had a where clause. Worked like a charm for months.

"TurkBear" <johng_at_mm.com> wrote in message news:39a2e9d4.8737804_at_news...
>
> 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 Thu Aug 24 2000 - 01:08:28 CDT