Excel table has a lot of data, you need to import data into the database, not a manual input, you can generate SQL, to bulk operations.
1. First in the second row of the H column, insert the function: =concatenate ("insert INTO ' book ' (' BookID ', ' title ', ' volume ', ' Author ', ' Urlpdf ') VALUES ('", A2, " ', ' ', B2, ' ' ', ' 3 ', ', ' C2, ' ', ' ', F2, ' '); '), which represents fetching data from each column into a function.
2. Write h2:h100 in the upper left, indicating that in H column, from the function automatically generate 2 rows to 100 rows, press Ctrl+enter, select the specified column:
3. Move the cursor to the end of the FX function above and press Ctrl+enter to generate the SQL statement:
at the end of the H column at the top of the "H" label, right-click on the copy, the successful copy of all the SQL statements, and then the SQL statement executed in the database is OK, successfully input Excel table data into the database.
Generate bulk SQL from an Excel table and enter data into the database
