Results 1 to 4 of 4

Thread: Upload data

  1. 05-22-2007, 12:04 AM #1
    sudhuajkey
    sudhuajkey is offline Registered User
    Join Date
    May 2007
    Posts
    2

    Upload data

    How can i upload data from access database into oracle
    Reply With Quote Reply With Quote
  2. 05-23-2007, 08:15 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can export data from access into CSV file then use SQL Loader in Oracle to load it.

    You can also use Linked table from Access to directly insert into Oracle table.
    Reply With Quote Reply With Quote
  3. 05-23-2007, 08:49 PM #3
    sudhuajkey
    sudhuajkey is offline Registered User
    Join Date
    May 2007
    Posts
    2
    thanks skhanal!!!
    But i am not familier with CSV
    can u explain in details
    Reply With Quote Reply With Quote
  4. 05-24-2007, 11:02 AM #4
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You need to export the data from Access to a standard format, CSV (comma separated values) is one way. You could also use Tab separated values.
    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