Possibility of updating database...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Possibility of updating database...

  1. #1
    Join Date
    Aug 2003
    Location
    Virginia
    Posts
    392

    Possibility of updating database...

    Hello. I'm running Oracle 9.2.0.1.0 on Windows 2000 Pro. A downloaded version with the "usual" installation.

    I've got a small Oracle database using Microsoft Access to enter the data, view reports. I also use Access's query tool to gather data for reporting. There are only 70 records in this database.
    I'm using ODBC to link Oracle and Access

    I would like to know how I could enter the data through Access and have it updated in Oracle, and I would like to know how to enter data through SQLPlus and have it updated in Access.

    I apologize for any incoveniences if the manner to achieve this is through ODBC, I missed it.

    Thanks

    Rick
    Rick

    Sigh.....those were the days my friend, I thought they'd never end.
    I too remember when this place was coo.


  2. #2
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    Just Link the necessary tables instead of import. I tried before.

    ---------------------------------------------
    OCA,OCP,OCM,OC? (9i,10g,11i,12?,XXX)
    Title is not to be proud

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width