Excel imports databases such as Mysql\oracle\sql server

Today the customer gave an Excel data, need and my local library data to do contrast, do not want to use the UE initialization, feel very troublesome, finally found a formula on the net slightly modified a bit to solve, memo as follows:

1. Add a column to the column you want to insert in Excel, and then enter the following code (please replace A2 and B2 with your own cell name, separated by commas in the English state)

   =concatenate ("INSERT into B_code (N_code, C_name) VALUES ('", A2, "', '", B2, "');")
   

2. Click on the lower right corner of the cell that you just added, and then click on the Cross and drag it down to the last record.

3. Select the new column column, CTRL + C copy, then go back to the statement execution form, CTRL + V paste, and then execute!!!

As follows

Excel imports databases such as Mysql\oracle\sql server