Import the data of the Excel table with SQL * Loader to Oracle Table

zhaozj2021-02-16  64

1. Save an Excel document as a comma-separated CSV file. (Note: Please go to the watch line)

2. Generate a control file as follows, Test.ctl:

Load Data Infile 'D: /Test.csv' Append Into Table Table_name Fields Terminated By ',' (Field_Name1, Field_Name2)

3. Row the following import statement in the DOS prompt:

D: / sqlldr userid = test / pwd @ server control = D: /TEST.CTL

转载请注明原文地址:https://www.9cbs.com/read-15285.html

New Post(0)