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

On Fri, 12 Dec 2003 13:21:45 -0800, gajaya1 wrote:

> 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

You don't do anything like that. You do not transfer data from oracle to access. You read the oracle database with MS Access. There is something called ODBC which can make MS-Access read oracle database. You see, oracle RDBMS is a database and MS-Access is a reporting tool which impersonates a database. The Only Right Way (TM) is to use a reporting tool to read the database and not to use the database to push a report toward the reporting tool. You have to learn the Tao.

-- 
None of us is as dumb as all of us.
(http://www.despair.com/meetings.html)