How to read the data from the xl sheet and load into a table? to
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to read the data from the xl sheet and load into a table? to

  1. #1
    Join Date
    Dec 2000
    Posts
    95

    Question How to read the data from the xl sheet and load into a table? to

    Hi All,

    How to read the data from the xl sheet and load into a table?

    The XL sheet contains four columns and 55 thousand rows, and I need to read that data from XL sheet and load the same into a table.

    Thanks in advance.

    Regards,
    Srinivas Medukonduru

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Two solutions I have used:

    For one-off cases:
    1) create INSERT instructions in an additional column of the worksheet, copy & paste them into a text file, execute them with a "@textfile.txt" in SQL*Plus.
    Might not be efficient enough for 55K rows!

    For frequent use:
    2) save the file in .csv format, load this with SQL*Loader.


    Another solution - I've tried bits of this, but never all together:
    3) load the Excel into Access and update the db with ODBC. This might lend itself to a "batch" solution with an Access macro.

  3. #3
    Join Date
    Jan 2002
    Posts
    78
    The Last option - sending the xl sheet into access database and export that into oracle ODBC is easy to upload the xl data into oracle database

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