Plsql Developer Importing Excel data

Scene: Recently in the statistics of overtime records, mainly statistics Excel table time, because I am not very familiar with Excel table operation, so I think of the table data import into the database, through the scripting language to statistics, it is very convenient! But for the time being, I have not finished the final statistics, just import the data in Excel into the database, so not to be continued!

The recent process of importing Excel data into Oracle is much more. Previously, it was handled in the same way as the SQLLDR command line import. Each time you import Excel table data in a different format, you need to convert the Excel file from ". xls" format to ". csv" format, and then manually create the corresponding data table according to the Excel file, and then modify the ". CTL" configuration file, the operation is more troublesome. Today, when I look at the Plsql Developer menu, I find that the "ODBC importer ..." feature in the tool is not only import Excel data, but also import data from dBASE, MS access. 1 Operation Steps

The specific import operations are as follows:

1. Click on the "Tools"-"ODBC importer ..." menu to open the Import function.

2. Select the type of connection and the Excel file to import


3. Select the "Sheet" table for which you want to import data you can see the excle table you want to import after you finish the above steps

4. Create Oracle data table based on sheet table structure
PS: This step is not to import data, is to create a table corresponding to Excel tables! Here you can modify the name of the table field so that it corresponds to the data in Excel later!


PS: Table Space properties are not very clear, I do not set here, directly using the default is OK!

By doing this, you create an empty table structure that corresponds to the Excel table!

5. Complete data import (import data from Excel) Click "Tools"-"ODBC importer ..." menu, switch to the label shown! This step is mainly to complete the import data and the data table you just created the correspondence between, here also set the data type to import data, to combine their own needs to set!I need to import the time format data here, but there is always a problem, and finally can only be imported in string format, so the subsequent operation is not finished!

2 Script Statistics Results

Not to be continued

(GO) Plsql Developer Import Excel data