|
Home > Archive > MS Access Database with External Data > September 2005 > Get Data From Oracle DB Into Access??
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Get Data From Oracle DB Into Access??
|
|
|
| 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
| |
|
| Use Linktable in Access, that way you will always have upto the minute Data
in Access
"VJ" wrote:
> 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
|
|
|
|
|