How to use "Update Row" - DBUpdateTool - Excel

... by Hi-Neko in Excel DBUpdateTool October 20, 2020

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]

1. If you want to add a new row to a database table, create an Excel sheet with that table name and create a header.

DBUpdateTool_CreateHeader_103_en

Enlarge the previous image for clarity.

DBUpdateTool_CreateHeader_103_Expansion_en

2. After creating the header with DBUpdateTool, enter the data you want to add in the Excel sheet.

DBUpdateTool_UpdateRow_101_Expansion_en

3. Select any cell in the row you want to add and click the "Update Row" button of the "DBUpdateTool" in the "Add-ins" tab of Excel.

DBUpdateTool_UpdateRow_102_Expansion_en

4. A confirmation dialog will be displayed as the data in the database will change.

DBUpdateTool_UpdateRow_103_en

5. The process is completed successfully.

DBUpdateTool_UpdateRow_104_en

6. The data in the database has been updated. In this case, the SQL INSERT process was executed because the same primary key data does not exist.

DBUpdateTool_UpdateRow_105_Expansion_en

7. As you can see, if you check it in Microsoft SQL Server Management Studio, you can see that the data is certainly registered.

DBUpdateTool_UpdateRow_106_Expansion_en

Lasis Corporation