Current Position:Home > Upload excel sheet data through sqlloader into oracle tables

Upload excel sheet data through sqlloader into oracle tables

Update:10-11Source: network consolidation
Advertisement
hi everyone,
i am working with excel sheet with following records
8501      Jacob Marshall      15000      21/10/2009      Finance
8502      Chris Campell      50000      13/06/2008      R&D
8503      Simon Dough      50000      3/07/2008      Engineering
8504      Mark Haggai      75000      9/3/2006      Product Management
8505      Verica Beverley      45000      7/2/2008      HR
and i saved it in emp_details.csv
after that when i write following code to make control file
load data
infile 'C:\Documents and Settings\prashant_dabral\Desktop\a.txt'
into table tmp
field terminated by','optionally enclosed by" "
(emp_no,emp_name,salary,doj,dept_name)
after this pl\sqldev returning me error message that ORA-00900:invalid sql statement
can anybody tell me how to resolve issue
or
another method to Upload excel sheet data through sqlloader into oracle tables

The Best Answer

Advertisement
A control file is a file located on the operating system, not some SQL or PL/SQL code you try and execute.
Create the control file as a file and then use that to load your data with SQL*Loader from the command line.
http://www.morganslibrary.org/reference/sqlloader.html
Or better still, create it as an external table and then you don't need a seperate control file or need to use sql loader from the command line...
http://www.morganslibrary.org/reference/externaltab.html
  • Upload excel sheet data through sqlloader into oracle tables Update:10-11

    hi everyone, i am working with excel sheet with following records 8501      Jacob Marshall      15000      21/10/2009      Finance 8502      Chris Campell      50000      13/06/2008      R&D 8503      Simon Dough      50000      3/07/2008      Engine

  • Uploading  Excel sheet  data into internal table Update:11-30

    Hi All, I want to upload Excel file data into internal table. My problem is that my excel file  having more than one sheets. I want to upload  the data of particula Excel sheet.. Please suggest me how can I upload particulat Excel sheet data . Thanks

  • Error in uploading excel sheet data into internal table Update:10-11

    Dear all, i am facing problem when uploading data from excel. i used KD_GET_FILENAME_ON_F4.i select the file and pass on to ALSM_EXCEL_INTO_INTERNAL_TABLE.and i get the ERROR....   Illegal type when transferring an internal table to a FORM. this is m

  • Uploading an excel sheet data using Oracle APEX 3.2 Update:11-30

    Hi All, Please help me out to upload excel sheet data using oracle APEX 3.2. Am following the steps mentioned in the below link, but even after that am getting an error saying no data found http://avdeo.com/2008/05/21/uploading-excel-sheet-using-orac

  • Upload Excel sheet using Data Integrator 6.1? Update:10-11

    hi all , Upload Excel sheet using Data Integrator? and how to create ODBC for the PC and jobserver i am using version 6.1? i am using excel as my one of the data source and tell me how to use different types of data sources in DI . after uploading th

  • Regarding uploading excel sheet in eCATT Update:11-30

    Hi, I would like to know how to upload excel sheet in ecatt.I am using 6.4 version.I have created a test script and test configuration.It would be great if anyone suggests me the procedure or path how to upload excel sheet to test the scripts. Thanks

  • Uploading Excel sheet in LSMW Update:11-30

    I am facing problem with uploading Excel sheet in LSMW. However, when I try to upload same data through tabulated file, its working perfectly fine. Please suggest the required solution.Thanks a lot !!! Your solution really helped. However, one correc

  • How to Upload Excel sheet in DB or internal table using SAP NetWeaver ABAP Update:10-11

    Dear All experts, Pls provide guidance  to Upload Excel sheet in DB or internal table using ABAP in  ( SAP NetWeaver stack  ) Regards Machindra Edited by: Machindra Patade on Apr 8, 2010 3:07 PMPlease search before posting. Thread locked. ThomasRead

  • Read and write excel sheet data from uploded file in sharepoint site programmatically 2013 Update:10-11

    hi team, I am working on sharepoint 2013.I want to read and write data in excel sheet (micrsoft excel) from stored file in shrepoint docoumnt library .please suggest me vijayHi Vijay, check those links http://www.sharepointwithattitude.com/archives/6

  • Uploading excel sheet in BDC Update:11-30

    Hi Abapers,       I had  doubt regarding uploading excel sheet using BDC. I dont know how to upload excel sheet,after executing the BDC program in a go, i.e.. after executing the program i have to press ENTER for each & every record to upload(this s