Access Link tables in Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Access Link tables in Oracle

  1. #1
    Join Date
    Sep 2001
    Posts
    200

    Access Link tables in Oracle

    hi all,
    I have a requirement to move Access tables to Oracle. Honestly I have no clue where to start. I need some material for the process. Can anyone direct me where to find this process?
    Thanks
    Life is what is happening today while you were planning tomorrow.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    Create an odbc connection to your Oracle database. Create the new tables on Oracle. Link the Access database to your new tables in Oracle. Create an insert query in Access to move the data over.
    this space intentionally left blank

  3. #3
    Join Date
    Sep 2001
    Posts
    200
    Quote Originally Posted by gandolf989
    Create an odbc connection to your Oracle database. Create the new tables on Oracle. Link the Access database to your new tables in Oracle. Create an insert query in Access to move the data over.
    Thanks for the eye-opener. that's great for a start...
    does anyone have a doc on this or a link to one?
    Life is what is happening today while you were planning tomorrow.

  4. #4
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    "What is past is PROLOGUE"

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