Read data from excel sheet and then perform the required operations.

Advertisement

Hi all
I need to write a procedure which can read data from excel sheet.I have excel sheet in which i have to options one is modification and other is addition.so if it reads modification then i need to read the concerned table name then check its availability in pl-sql datbase.If table exists then reading the realated column in that row to fire the querry. The excel sheet is saved in local disk c.
can anybody help me with this.How i need to start specialy to read the data from excel sheet saved in local disk c.
Edited by: user13334062 on Jun 30, 2010 3:45 AM

Advertisement

Hi
If you can convert the excel to a csv format, then it can be simply query from DB Creating Oracle External Tables. Best part is that you may still change the CSV using EXCEL.
Following action Points can be adopt;
*1. Convert Excel File to a csv. File Save as CSV*
*2. Create Oracle Directory* ( This has to be the location of your excel file )
SQL> Create directory mydir as 'C:\testdb'; --- "testdb" is the location folder in win for your excel sheet.
*3. Create the External Table*
SQL> create table my_ext_tab (
Field1 Datatype,
Field2 Datatype,
Field3 Datatype,
Field4 Datatype,
Field5 Datatype
Organization external
(type oracle_loader default directory mydir
access parameters (records delimited by newline fields terminated by ',')
location ('my_ext_tab.csv'))
reject limit 100;
*4. Now you can query the table "my_ext_tab"*
Select * from "my_ext_tab";
Please avoid the reformat the data column inside the spreadsheet (CSV).

October 11, 2015

Read data from excel sheet and then perform the required operations.

Hi all I need to write a procedure which can read data from excel sheet.I have excel sheet in which i have to options one is modification and other is addition.so if it reads modification then i need to read the concerned table name then check its av

Getting short dumps while reading bulky data from excel sheet

Hi all, We have converted our non-unicode based sap system (R/3 4.7, Windows 2003, SQL 2000) into a unicode based system recently. We are facing two peculiar problems for last few days. *Problem 1 - *Whenever we want to upload the data from excel she

Pasting data from Excel sheet to Table in web dynpro View

Hii All, Is it possible to copy data ( some rows) from Excel sheet and paste in table in a view? I tried doing this, but only first element is getting pasted.. Does anybody know how to do this? Is there any way to perform similar thing? Pls help. reg

Urgent - Migrate data from Excel sheets

Hello all.. I want to move data from excel sheets into oracle9i Database I have a bout 50 table with average of 5000 row per table How could I do it I will be so obligated if you could detail it for me Thanks in advanceI want to insert data using loa

Read data from multiple sheets

Hi, Can anyone tell me how to read data from multiple excel sheets? Thanks.Hi, go through this link this may help u. https://www.sdn.sap.com/irj/scn/wiki?path=/display/snippets/readmultiplesheetsofanExcelfileintoSAPthroughABAP&focusedCommentId=929302

Read data from xml files and  populate internal table

Hi. How to read data from xml files into internal tables? Can u tell me the classes and methods to read xml data.. Can u  explain it with a sample program...<pre>DATA itab_accontextdir TYPE TABLE OF ACCONTEXTDIR. DATA struct_accontextdir LIKE LINE O

It is possible to get data from Excel file and put them in BusinessObject Entreprise?

Hi everybody, How i can get the information (data table) from a excel file? I just want to open a file excel in BusinessObject Entreprise XI. It is possible? ThanksWhat is BI launch pad? BI platform includes BI launch pad, a web application that acts

How to delete the Junk Data From Excel Sheet

Dear ABAPers,             I am uploading the Excel sheet from the Desktop to the SAP System. In the Internal table i am getting Unwanted Junk data's for Example '##########'.I am not getting this Junk data for all the times. i am getting it for Some

Uploading Data From Excel Sheet to SAP Database Tables

Dear Friends, We are having an Excel Sheet with 90 different columns. Now we want only 2 of the columns to be uploaded in the database tables. So, Plz tell me which function module will be suitable for this. And plz help me with the code also. Thanks

HOW TO READ DATA FROM A FILE AND INSERT INTO A TABLE USING UTL_FILE

Hi.. I have a file.I want to read the data from file and load it into a table using utl_file. how can I do it? Any reply apreciated...Hi, This is not your requirment but u can try this : CREATE OR REPLACE DIRECTORY text_file AS 'D:\TEXT_FILE\'; GRANT

Uploading data from Excel sheet into SAP.

Dear All, I want to upload data existing in Excel sheet into SAP. Is there any possibility with the following requirements? 1) Excel file contains serial numbers with different values.Like power(230Wp),Voc,Isc,Vmp and Imp. 2) We need to upload the sa

Problem in loding data from excel sheet

hi , i hav some problem with sqlloader.i m using oracle8i this is my loader.ctl file load data infile 'c:\data\emp.xls'           into table employee fields terminated by "," optionally enclosed by '"'           ( empno, empname, sal, deptn

Waveform Graphs: Is there a way to save data to a file and then clear the graph after each run?

This is just an added feature that I would like to insert because I end up having to erase the previous graph(for viewing and simplification purposes) after almost every plot cycle. Does LabVIEW 7.0 have a built-in feature that allows the user to aut

Can I use Power Query to Import a table from Excel sheet range which starts not from the top row?

Hi, Being an experienced Excel user before Power BI, I am just starting to explore the M and Power Query capabilities, and need help already (ain't easy to google this use case somehow): I need to import the table which sits in the Excel file with he

Ugrent help. User exit- Read data from BW BPS layout and write to ODS

Hi, I am new to BW BPS and have a req. where i need to read data from BPS layout (EXCEL) and write it to ODS. Is there any function module or user exit which read data from excel layout and upload it to ODS. Or can any one help me out how can i write

Reg transfer of data from excel to internal table

hi i need to upload datas from Excel sheet to Internal Table.For this i use d FM ALSM_EXCEL_TO_INTERNAL_TABLE.but the problem is if a particular field has no value in excel sheet,then its not  uploaded into internal table.then next field value has co

Error while importing data from excel to forms

Hi, I am working on Oracle forms 10g, and I'm supposed to import data from excel sheet to forms. While the user enters the data,sometimes after entering a particular word he/she hits the alt+enter button. As a result the data appears in two lines in

Upload data from excel where one column has text of 3000 characters

Guyz, I have a query. One of my requirments is to upload data from excel sheet & create a material. In the excel sheet one of the columns has text for BASIC DATA TEXT under ADDITIONAL DATA of a Material. This is a text of running length. the selectio

How to downlaod vednor master data into excel sheet in SAP Application ser

Hi friends I want to download SAP vendor master data into excel sheet and the file should be stored in SAP Application server Location with padding zeros. Please help me. ThanksHi Ramesh, You can download the data into application server using the fo

Reading data from mlx90129 rfid tag chip by using spi communication with labview?

Hi,  i have evb90129 evalution board in that mlx90129 chip and external memory (cat25128) and three external sensors are there, i am logging data from chip by using rfid reader it ok i am reading. at the same time i configured spi communication and