EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

MS Excel/Word 2007, ODF


Specify ranges in the grid for the target and source fields:

  • select a field of the target SQL Server table in the Fields list;
  • proceed to the Sheet grid: 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 file and the tiodestination SQL Server table have the same order of columns, you can use the iconAutoFillColumns Auto Fill button to set correspondence between them automatically.

 

The Col control indicates the currently selected source file column. You can also use this control for quick column selection.

 

If necessary, you can choose to skip a defined number of the source file rows using the Skip spinner control (e.g. if you need to exclude column headers from the imported data range).

 

Import Data - Setting fields correspondence - MS Excel and Word 2007, ODF

 

 

To remove a correspondence, select the field in the Fields list and press the iconCross Clear button.

To remove all correspondences, press the iconClearAllRanges Clear All button.

 

 

Click the Next button to proceed to the Adjusting data formats step of the wizard.