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

Thread: Import Access Table into Oracle Database

  1. 02-24-2006, 02:23 PM #1
    dpora1979
    dpora1979 is offline Junior Member
    Join Date
    Feb 2006
    Posts
    5

    Import Access Table into Oracle Database

    Gurus,

    I have an Oracle 9i database and I'm using access 2000. What is the simpliest way to import an access table into an oracle database?
    Reply With Quote Reply With Quote
  2. 02-24-2006, 02:35 PM #2
    hacketta1
    hacketta1 is offline Senior Member
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    I'd personally save the table as a csv file or similar and use SQL*Loader or external tables to load into Oracle:

    http://download-west.oracle.com/docs...rt2.htm#436160

    http://download-west.oracle.com/docs...ables.htm#9046
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width