Re: Oracle and Microsoft access

I don't think there is a non-trivial way to access ( not Access) a non Oracle database from within Oracle in the way you want...You could, however, do the reverse...Set up a link to the Oracle database table from within Access and update at will...

Pierre Pavlenyi <pavlenyi_at_ca.ibm.com> wrote:

>I am trying to connect a Microsoft Access database to an Oracle database
>in the following manner:
>
>In Oracle, I want to know if I can create a table/alias (call it
>MSAccessAlias) that points to a table in the MS Access table. I then
>want to periodically (say, once a day), copy the contents of
>MSAccessAlias to an Oracle internal table (call it OracleMSReplica).
>
>Is this possible? If so, how would I go about implementing this
>solution?

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Fri Mar 17 2000 - 10:14:27 CST