Re: Oracle and Microsoft access

Let me rephrase my question:

I want to know if I can update the contents of a table in an Oracle database with the contents of a MS Access database using ODBC. i.e. MSAccess writes to Oracle. The table in Oracle already exists, and I _do not_ want to recreate it. I only want to repopulate it with the data from the MS Access table.

TurkBear wrote:

> You can use the Save As/Export command to send the Access Table to Oracle ( Not
> exactly an update, but a replacement..so drop the table in Oracle first...)
> Also. watch out for mixed and Lower case column headings in Access - they will
> be difficult to work with once the table is in Oracle...
>
> Pierre Pavlenyi <pavlenyi_at_ca.ibm.com> wrote:
>
> >Can Access, through ODBC, update an Oracle table? I was under the impression
> >that ODBC allowed Access Read-Only access to Oracle tables...
> >
> >TurkBear wrote:
> >
> >> 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! =-----
>
> -----= 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 - 11:30:54 CST