Go Excel generates bulk SQL statements, a great way to handle large amounts of data

When there is a lot of repetitive manual work writing or modifying data into the database, you can

First, after the Excel data has been collated, the SQL import function directly into the database, but to ensure that the database fields and Excel fields consistent.

Second, the corresponding SQL statements are generated by Excel, and the SQL statements are copied directly into the parser to execute.

For example: write to the database using Excel's formula:

= "INSERT into [student] (Userid,username,userpassword) VALUES ('" &A2& "', '" &B2& "', '" &C2& ') "

Where A2 is Excel column A, row 2, B2 is the 2nd column of Excel Row B.

Update Database fields:

= "Update [student] set username= '" &B2& "' Where userid= '" &A2& "'"

Pull from head to tail.

Go Excel generates bulk SQL statements, a great way to handle large amounts of data