.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

How to insert Excel sheet in the PLSQL database

Posted By:Ashutosh Jha       Posted Date: February 17, 2014    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

Inserting Excel sheet in PLSQL is different from what i explained in "Inserting CSV file in SQL database".
 

How to insert Excel sheet in the PLSQL database:-

Inserting Excel sheet in PLSQL is different from what i explained in "Inserting CSV file in SQL database". Here we follow the below steps-
1. Create table with the count of column same as you have in excel sheet.
2. Save the excel sheet in the location from where you can eaisly access it and don't remove the header (we usuallu do in case of csv sheet of CSV file).
3.Now click on tools and select ODBC Importer.
4. A window will get opened and in that window select Excel file in the first dropdown of User/SystemDSN.
5. No need to provide user anme and password.
6. click on "Connect" button. Once you will click this  a dialog box will open here select the file location where you have kept your excel sheet and select it.
7. Now click on "OK", in the table/Query window All the sheet of that excel sheet will be shown select the sheet in which you have data (by default we have in sheet 1-select it).
8. Now go to "Data to oracle tab". Here write the owner name and select the table name which you have created for this excel sheet insertation.
9. Now all the fields of excel sheet will be shown in Fields sheet area. select one and match with the column name from "Field" dropdown and select their datatype from FieldType "dropdown".
11. Finally click on "Import" button which is in bottom of the window.And after successfull operation it will write number of rows that you have in excel have been inserted.
How to insert Excel sheet in the PLSQL database:-

Inserting Excel sheet in PLSQL is different from what i explained in "Inserting CSV file in SQL database". Here we follow the below steps-
1. Create table with the count of column same as you have in excel sheet.
2. Save the excel sheet in the location from where you can eaisly access it and don't remove the header (we usuallu do in case of csv sheet of CSV file).
3.Now click on tools and select ODBC Importer.
4. A window will get opened and in that window select Excel file in the first dropdown of User/SystemDSN.
5. No need to provide user anme and password.
6. click on "Connect" button. Once you will click this  a dialog box will open here select the file location where you have kept your excel sheet and select it.
7. Now click on "OK", in the table/Query window All the sheet of that excel sheet will be shown select the sheet in which you have data (by default we have in sheet 1-select it).
8. Now go to "Data to oracle tab". Here write the owner name and select the table name which you have created for this excel sheet insertation.
9. Now all the fields of excel sheet will be shown in Fields sheet area. select one and match with the column name from "Field" dropdown and select their datatype from FieldType "dropdown".
11. Finally click on "Import" button which is in bottom of the window.And after successfull operation it will write number of rows that you have in excel have been inserted.

 

Happy Sharing !! cheers !!

 Subscribe to Articles

     

Further Readings:

Responses
Author: Ashutosh Jha         Company URL: http://www.dotnetspark.com
Posted Date: February 17, 2014

Hi all,

By mistake it has been pasted twice, please ignore one entry from the same article.

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend