Excel table data is imported into the Oracle database

Import an Excel table into the Oracle database

I. Establishment of a table

1. Create a table

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;padding-left:0px; padding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clipboard "border=" 0 "alt=" clipboard " Src= "Http://s3.51cto.com/wyfs02/M02/86/D9/wKioL1fNMdbC3eQfAACGtnt1sX4404.png" height= "195"/>

2. Enquiry Form

select * from yy;

Second, the Import program

1. Find the data you want to import in Excel

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;padding-left:0px; padding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clipboard "border=" 0 "alt=" clipboard " Src= "Http://s3.51cto.com/wyfs02/M00/86/D9/wKioL1fNMdfCFRUhAAHZL9KWrZ8135.png" height= "335"/>

2. Save the data in Excel as a text file (tab-delimited)

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;padding-left:0px; padding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clipboard "border=" 0 "alt=" clipboard " Src= "Http://s3.51cto.com/wyfs02/M01/86/D9/wKioL1fNMdjxMqB4AACBMN_UIPg273.png" height= "139"/>

3. Select Tools-->text Importer in Pl*sql, select "Data from Textfile" in the window that appears, then select "Open data File",

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;padding-left:0px; padding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clipboard "border=" 0 "alt=" clipboard " Src= "Http://s3.51cto.com/wyfs02/M02/86/D9/wKioL1fNMdrT9owvAAFx-qgGzaA371.png" height= "362"/>

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;padding-left:0px; padding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clipboard "border=" 0 "alt=" clipboard " Src= "Http://s3.51cto.com/wyfs02/M00/86/DB/wKiom1fNMduRsfCIAABmxpDEo6g110.png" height= "161"/>

In the pop-up File selection box, select the text file that holds the data, and you will see the data from Textfile displayed

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;padding-left:0px; padding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clipboard "border=" 0 "alt=" clipboard " Src= "Http://s3.51cto.com/wyfs02/M00/86/D9/wKioL1fNMdyA668DAAJIdVrFYAk125.png" height= "257"/>

4. Configure the configuration as follows

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;padding-left:0px; padding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clipboard "border=" 0 "alt=" clipboard " Src= "Http://s3.51cto.com/wyfs02/M01/86/DB/wKiom1fNMd6A3xl8AALccz2leIY366.png" height= "413"/>

Note: If the "name in header" is not checked, it causes the field name to be imported into the database as a record, resulting in a data error

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;padding-left:0px; padding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clipboard "border=" 0 "alt=" clipboard " Src= "Http://s3.51cto.com/wyfs02/M01/86/D9/wKioL1fNMeLz3hvFAAMFLvqkuXc288.png" height= "444"/>

5. Click Data to Oracle, select the table that will import the data and associate the fields in the text with the fields in the table

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;padding-left:0px; padding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clipboard "border=" 0 "alt=" clipboard " Src= "Http://s3.51cto.com/wyfs02/M00/86/D9/wKioL1fNMeOR1zyxAAEbFWRScV0587.png" height= "334"/>

6. Click the Import button

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;padding-left:0px; padding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clipboard "border=" 0 "alt=" clipboard " Src= "Http://s3.51cto.com/wyfs02/M00/86/DB/wKiom1fNMeSjHp-eAAEHC9XD-tA336.png" height= "407"/>

7. View the imported data

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;padding-left:0px; padding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clipboard "border=" 0 "alt=" clipboard " Src= "Http://s3.51cto.com/wyfs02/M02/86/DB/wKiom1fNMeaCQpZOAAG9ERk3E4g601.png" height= "346"/>

OK, this data import is successful.

This article is from the "willing to share with you" blog, please be sure to keep this source http://pengjc.blog.51cto.com/9255463/1846475

Excel table data is imported into the Oracle database