This topic guide you through the process of generating the INSERT profile query within the Query Wizard. To learn how to start the wizard and how to select the query type see topic Query Wizard.
The first step of the INSERT Query Wizard allows you to select tables and columns to include into the query.
Select the table name from the Tables drop-down list and move table columns from the Available Fields list to the Selected Fields. Note, that you can select fields from multiple tables.
The next step of the wizard allows you to define the values you want to insert into the table(s).
The upper caption of the grid stands for the target table name, and the next caption row displays the column name. Type the values into the appropriate cells to insert them into table columns. You can enter as much values as you need.
With the next step of the wizard you can set additional query parameters.
To learn more about such query parameters, as low priority or ignore errors, please refer to the Designing Query Options topic.
The final step of the wizard allows you to select the action to perform after the creation and displays information about the creation errors, if such occur.
Select Open the query in design mode to open the Query Designer after the query is created. To execute the query and apply the selected modifications to table data, select Execute the query. To close the wizard without any action after creating the query, select the Take no action item.
To create the query with all the parameters you have set, click the Finish button.
©2004 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.