Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to: External Tables attached directly to a MS Access mdb file???????
What is he Best way scedule the data transfer day to day basis using a
command line program.?
Mladen Gogala <mgogala_at_adelphia.net> wrote in message news:<pan.2003.12.13.04.54.48.260305_at_adelphia.net>...
> 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.
Received on Sat Dec 13 2003 - 21:14:41 CST