Import excel files through PL/SQL

PL/SQL is similar to SQL Sever in importing excel data. It is used to find a function to import excel Data. follow the steps below. The following is a detailed process, hoping to help cainiao like me. Www.2cto.com 1. Prepare an excel worksheet. Right-click the data table and choose edit data. select data, right-click, select Copy to Excel 2. Adjust the excel table to delete column A and column F, and then paste your data to the BCDE column, the advantage of this is that when importing an excel file, there will be no errors caused by format or other text problems. Www.2cto.com 3. Prepare to import and select tool-ODBC Importer. There are three items in User/SystemDSN, here we need to select the second Excel Files select Connect in the pop-up box, select the excel file you want to import to preview your Data, and then click Data to Oracle to add the owner, and the data table you want to add. Here is T_Admin, and then click import. 4. View data: the imported data already exists.