This is the menu of the process to get the SQL statement.
For all rows, compare the cell and DB data, and if there is a difference, change the background color of the cell to express the difference. After that, the data in the DB is compared with the existing data in the Excel sheet to get the record that does not exist in the Excel sheet.
For the selected row, set the cell value of the primary key as the "WHERE" condition, and "INSERT" or "UPDATE" the cell data into the DB. If there is no existing data, perform "INSERT", and if there is existing data, perform "UPDATE". [Multiple lines can be selected]
Introducing how to install DBUpdateTool. You can easily complete the installation by following the installer and clicking. It's an Excel add-in, not an Excel macro, so if you install it on your PC, you don't need to include the program in your Excel file.
I'm "Hi-Neko" from the LASIS Support Center. We will continue to develop better products, so we look forward to working with you.