How to load data in MS EXCEL SHEET into table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to load data in MS EXCEL SHEET into table

  1. #1
    Join Date
    Jan 2001
    Posts
    4

    Unhappy

    Can anybody please help me how to load data from MS EXCEL sheet to tables.
    Thanks in advancve.

  2. #2
    Join Date
    Jan 2001
    Posts
    28
    There are 2 ways for that, one save the excel sheet as a csv file and then use sqlldr to load the comma delimited file into oracle table.
    Else, if you have MS Access, copy the data from XL and paste it onto the table in access.

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