Re: MS Access selecting from Oracle database

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 12 Mar 2008 12:40:19 -0700
Message-ID: <bf46380803121240h45f3c988u7ef30635694dc646@mail.gmail.com>


On Wed, Mar 12, 2008 at 11:41 AM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:

> We have a user who wants to select information into Access from Oracle.
> What has to be setup to do this?
>
>

You must need to setup ODBC access to an account on the database.

Access will let you link to the tables in Oracle.

Beware though - if you drop/recreate any tables that are linked to in Access, the
links in Access will need to be recreated.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 12 2008 - 14:40:19 CDT

Original text of this message