Heterogeneous Services allows you to access ODBC/OLEDB datasource from
within Oracle. The catch is that the Oracle server must be able to see
those datasources.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
news:3fda3c3d$0$18386$afc38c87_at_news.optusnet.com.au...
>
> <gajaya1_at_netscape.net> wrote in message
> news:ef6582c0.0312121321.3aa2e521_at_posting.google.com...
> > I only find information connecting Oracle external tables to data
> > files. But I dont want to transfer data to files instead I want
> > directly transfer data to oracle from Access. I do not know how to
> > change the syntax of the below External table binding
>
>
> I'm not precisely sure what you're asking, but external tables are only a
> way in Oracle to read text files as though they were regular tables. Text
is
> (currently) the only source, and it is not possible to 'plug in' Access
> mdb's.
>
> If you are therefore trying to view Access data from within Oracle, then
> external tables are not the way to go.
>
> Regards
> HJR
>
>
Received on Fri Dec 12 2003 - 16:35:16 CST
