Data Merge Wizard

Data Merge Wizard

The Data Merge Wizard lets you merge data from Excel tables into database tables.

You can merge Excel data sourced from web pages, text files, or other locations.

The wizard inserts and updates row values in columns that exist in the target table.

Ensure that the primary key columns of the target table are present in the Excel table.

You can create formula columns named after target columns to satisfy this requirement.

The add-in updates the MergeDate and merge_date fields in the database with the time the script was generated.

It also saves the configuration of the wizard, allowing you to use the Merge button in the Save Menu to repeat the merging process later.

The wizard consists of four steps:

  1. Selecting a provider
  2. Connecting to a database
  3. Selecting a target table
  4. Executing the script

Excel Table Requirements

The Data Merge Wizard requires Excel tables, which should be named "Lists."

To run the wizard, select any cell within the table you want to merge.

If the wizard is disabled, create an Excel table by selecting the desired range and clicking Insert > Table from the Excel menu.

Inserting Excel Table

Step 1. Selecting Provider

Choose the desired data provider as outlined in the Database Connections topic.

Data Merge Wizard - Selecting Provider

Step 2. Connecting to Database

Connect to a database as described in the Database Connections topic.

Data Merge Wizard - Connecting to Database

Step 3. Selecting Target Table

Select the target database table where you want to merge the Excel data.

Here's a sample of the step:

Data Merge Wizard - Selecting Target Table

Step 4. Executing Script

The wizard displays a generated script. Click the Execute button to run it.

Data Merge Wizard - Script to Execute

Data Merge Wizard - Script Results

If you encounter a timeout exception, increase the command timeout in the Options dialog box.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.