Online Documentation for SQL Manager for SQL server
Set correspondence between the target table fields and the source HTML file columns:
- select a field of the target SQL Server table in the Fields list;
- proceed to the source grid viewer area: select the Table from which you intend to import data and click a column to assign the column to the selected target table field;
- the selected column of the source file gets gray highlight;
- repeat the operation for all the fields you need to be included in the import process.
If the source HTML file and the destination SQL Server table have the same order of columns, you can use the Auto Fill button to set correspondence between them automatically.
The Col control indicates the currently selected source file column. You can also use this spinner control for quick column selection.
If necessary, you can choose to skip a defined number of the source file rows using the Row spinner control of the Skip group (e.g. if you need to exclude column headers from the imported data range).
To remove a correspondence, select the field in the Fields list and press the Clear button.
To remove all correspondences, press the Clear All button.
Click the Next button to proceed to the Adjusting data formats step of the wizard.