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.
2. From the menu "File", click "Connect Object Explorer" to connect to SQL Server.
3. Open the Object Explorer tree in Database> System Database> master Schema> Tables and create a new table with the name Account.
4. Next, create a new table with the name "AccountEMail".
5. If you display the data in each table of "Account" and "AccountEMail" as shown below, you can confirm that the data is empty.
6. Open the Excel file created for DBUpdateTool and enter the database connection information in the "@Config" sheet.
7. Then create a new sheet and rename the sheet to "Account".
8. Select the Add-ins tab in the Excel ribbon menu. Click the "Header Operation" > "Create Header" button in the "DBUpdateTool2020" menu.
Enlarge the previous image for clarity.
9. As you can see, the header for the "Account" table has been created.
10. Similarly, if you create an "AccountEMail" sheet and perform "Create Header", the header of the "AccouneEMail" table will be created.
I'm "Hi-Neko" from the LASIS Support Center. We will continue to develop better products, so we look forward to working with you.