Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Exclamation Unanswered: loading data to a oracle table from XLS using TOAD

    Hi,

    I hav a XLS sheet with coloum headers(fields of oracle table) and data in it. I hav to load the data to oracle table from tht XLS.
    Pls provide me the SQL/procedure to do the same through TOAD.

    -nita

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    You cant load xls data through TOAD. You have 3 options
    1) save the file as csv and use sqlloader
    2) write an excel VBA macro (using the Oracle OLEDB driver) to go through each cell in the sheet and insert it into the oracle table.
    3) find a comercial app to do it
    4) write an excel macro to convert each row in the sheet into an insert statement which you the copy into TOAD and execute

    Alan

Posting Permissions

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