Re: Oracle to access

To use Access as a front-end to Oracle, you need BOTH Oracle SQL*Net and the Oracle ODBC drivers (available from the Oracle website in a typically large package complete with Oracle Installer program.) Also keep in mind that SQL*Net and the ODBC driver come in 16-bit and 32-bit flavors. Access 2 REQUIRES the 16-bit versions; Access 7 REQUIRES the

32-bit versions.  You CAN have both on the same machine (Access 2 +
16-bit ODBC and 16-bit SQL*Net, at the same time as Access 7 and the
32-bit Oracle stuff.)

This works pretty well. We are accessing large (million-row) tables this way.

mike wrote:
>
> Yes,
>
> You need to use the Oracle ODBC drivers and you can have direct connect to
> Oracle
> DB using MS-ACCESS. With that you can I suppose "import" your data to
> access.
>
> If you need the ODBC drivers, I think it is available from Oracle Website.
>
> Mike
>
> Doug Lane <app1del_at_is.ups.com> wrote in article
> <330DDD84.29F6_at_is.ups.com>...
> > Is there any way to easily pull data from an Oracle db and put it into
> > an Access db, assuming the two have the same table structures? Thanks,
> > Doug
> > --
> > -----------------------------------------------
> > Doug Lane v: (502) 329-3754
> > Programmer/Analyst f: (502) 329-3597
> > United Parcel Service e: app1del_at_is.ups.com
> >
  Received on Sat Feb 22 1997 - 00:00:00 CET