Re: How to: External Tables attached directly to a MS Access mdb file???????

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 13 Dec 2003 09:07:56 +1100
Message-ID: <3fda3c3d$0$18386$afc38c87@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:07:56 CST