Update

To selectively update a part of an existing table, expand the Upload Type listbox and click update.

In the Key Columns field, type the name or names of the column or columns that you want to update.

The file that you specify in the File Name field should contain the same number of columns of data as the number of names in the Key Columns field. For example, if you type three column names into the Key Columns field, the table should contain three columns of data.

When the macro runtime performs the update operation, the database server replaces the specified columns of data with the data from the specified file. For example, if table zietest has 8 rows and 250 columns, you can update the first, second, and seventh columns of the table.