Re: Oracle and Microsoft access

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:24:52 CST