Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2006
    Posts
    2

    Unanswered: Migration table data from CSV\Excel file to Oracle

    Hi

    I'm using oracle 9I enterprise edition (9.2.X.X).

    I need to copy data , resides in CSV & Excel file into Oracle table ( the field are named the same)

    I want to do it directly without loading the data into cache object
    (ADO.NET Dataset and such )

    Is there any Oracle \ 3D freeware tool for it ???

    Thanx in advance

    Daniel

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    CSV files can be loaded into Oracle database using SQL*Loader or, if you want to research a little bit further, using those files as "external tables".

    I wouldn't know how to load a pure MS Excel (.xls) file into Oracle, but I *think* there was a topic on this forum earlier (if not on Oracle forum, try Applications and Tools forum) where this subject was discussed.

  3. #3
    Join Date
    Jan 2004
    Posts
    99
    well you could save the file as CSV and use the sqlloader utility to load data into oracle.

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    OR also you can use MS Access and "link" the csv, Excel and Oracle tables -- then apply SQL statements on these tables.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    May 2004
    Location
    Pune, India
    Posts
    15

    data from .xls file to oracle

    Hi,
    Is there any way to import data from .xls file into oracle? Without saving it as csv file?

    There is some problem when we try to save the xls file as csv file.
    Thanks in advance.
    regards

    Abhivyakti

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    Quote Originally Posted by Abhivyakti
    Hi,
    Is there any way to import data from .xls file into oracle? Without saving it as csv file?

    There is some problem when we try to save the xls file as csv file.
    Thanks in advance.
    regards

    Abhivyakti
    describe the problem.
    you are aware you have to click "file" then click "save as" and then click the "save as type" dropdown and select "CSV"? Otherwise you can "save as" and convert it to a text file or almost anything.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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