How to use "Create Header" - DBUpdateTool - Excel

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

Create a header based on the "Sheet" name or the table name entered in the "A1" cell.

1. The database connection settings and the specified table must already exist in the database to complete this operation. The procedure is described below using SQL Server as an example. First, launch SQL Management Studio to work with SQL Server.

SQL_Server_Management_Studio_101_en

2. From the menu "File", click "Connect Object Explorer" to connect to SQL Server.

SQL_Server_Management_Studio_102_en SQL_Server_Management_Studio_103_Expansion_en

3. Open the Object Explorer tree in Database> System Database> master Schema> Tables and create a new table with the name Account.

SQL_Server_Management_Studio_104_Expansion_en

4. Next, create a new table with the name "AccountEMail".

SQL_Server_Management_Studio_105_Expansion_en

5. If you display the data in each table of "Account" and "AccountEMail" as shown below, you can confirm that the data is empty.

Account

SQL_Server_Management_Studio_106_Expansion_en

AccountEMail

SQL_Server_Management_Studio_107_Expansion_en

6. Open the Excel file created for DBUpdateTool and enter the database connection information in the "@Config" sheet.

DBUpdateTool_CreateHeader_101_Expansion_en

7. Then create a new sheet and rename the sheet to "Account".

DBUpdateTool_CreateHeader_102_Expansion_en

8. Select the Add-ins tab in the Excel ribbon menu. Click the "Header Operation" > "Create Header" button in the "DBUpdateTool2020" menu.

DBUpdateTool_CreateHeader_Expansion_en

Enlarge the previous image for clarity.

DBUpdateTool_CreateHeader_Expansion2_en

9. As you can see, the header for the "Account" table has been created.

DBUpdateTool_CreateHeader_103_Expansion_en

10. Similarly, if you create an "AccountEMail" sheet and perform "Create Header", the header of the "AccouneEMail" table will be created.

DBUpdateTool_CreateHeader_104_Expansion_en DBUpdateTool_CreateHeader_105_Expansion_en

Lasis Corporation