How to import excel data to the database

1. Save the excel file as. csv.

2. Use Notepad to open the. csv file. The first line is all fields.

3. Create a table structure

Create table yu_rt_01 asselect Transaction_Id, Last_Update_Date, Last_Updated_By, Creation_Date, Created_By, Last_Update_Login, Request_Id,..., fig where 1 = 2;

4. No data in the checklist

5. Open Toad for Oracle

6. Connect to the database

7. Database-> Import Table Data

8. Select Table yu_rt_01

9. Click show data. It is empty now.

10. Next

11. Import form = text. File is the. csv File just saved.

12. Next

13. Change First Row to 2.

14. Keep all others by default. Click commit.

15. select * from yu_rt_01