How to import Excel data into the database

1. Save Excel as a. csv format

2. Open the. csv file with Notepad, and the first line is all the 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,..., Lcm_shipment_line_idfrom rcv_transactions where 1=2;

4. There is no data in the checklist

5. Open Toad for Oracle

6. Connect to the database

7. Import Table Data, import, Database

8. Select Table Yu_rt_01

9. Click Show data, it is now empty

Ten. Next

One. Import form = text, file is the. csv file that you just saved

Next

First Row changed to 2

14. All other remains default, click Commit

. SELECT * from yu_rt_01