Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    São Paulo, Brazil
    Posts
    9

    Unanswered: Export MS Access to Oracle

    Hi

    I am trying to export tables from Access to Oracle 8 via OBDC.

    It works fine for small tables (20 records) but for large tables I get a error that the register is to large.

    Any ideas to solve this problem ??

    Robin

  2. #2
    Join Date
    Apr 2002
    Posts
    56
    I don't know about that register, but you could export the large tables to text files and load them into Oracle with SQL Loader.

  3. #3
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    You can aslo used sql server tool . It can export data from excel to oracle. Or u can save excel file as csv and used sql loader as said by
    edwin

    Thanks,
    Pagnint
    (No need to search web before posting new question)

Posting Permissions

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