INSERT ROWS IN ORACLE WHILE CONCATENATING ROWS IN EXCEL USING CONCATINATION

INSERT ROWS IN ORACLE WHILE CONCATENATING ROWS IN EXCEL USING CONCATINATION

WE can simply insert the excel data into oracle while making the insert query in excel sheet itself.

So this is done by concatenating the excel columns and writing the query ...let see how it can be done:::

Step1.

Let this be test excel sheet with some data.

IMG1:

Now we need to upload this data into database.

Their are several ways of doing this as explain in my other articles..

http://asp-netpiyush.blogspot.in/2013/09/export-excel-sheet-data-in-oracle-via.html

but now we will write the insert query in exel sheet itself and upload the data in database by running the query.

STEP2:

THE CONCATINATE FUNCTION of excel can be used to write the query as:

=CONCATENATE("INSERT INTO TESTTABLE VALUES('",A2,"','",B2,"','",C2,"',",D2,",'",E2,"');")

This will result in :

INSERT INTO TESTTABLE VALUES('PIYUSH','TEAM MEMBER','DEVELOPER','22','985377xxxx');

IMG2:

Like wise you can create any query and run it in database.