Get Data From Oracle DB Into Access??

[VJ]

Hello All,

I am looking for a way to import data in to Access 2003 from a table in our
Oracle database residing on the server using the MS ODBC drivers to avoid
installing the Oracle Client on the workstation. Also, this has to be done
with no external coding - i.e. only using Access and Oracle. All the person
is looking to do is get the records in access so he/she my view it.

I've been looking on the net but almost all links I found so far involve the
oracle client manipulation. I've also searched here and all links pertain to
some sort of coding.

If such a connection is possible, could someone list out the steps to show
me how to do it? If not, what would your suggestions be? The important thing
here is to avoid the use of the Oracle Client, an application, or tool to
access the info.

Any help is very much appreciated,

Thank you,
VJ

 

[N S S]

Use Linktable in Access, that way you will always have upto the minute Data
in Access