Online Documentation for Data Import for SQL Server

MS Access


Switch between existing Access table and custom Access SQL query to retrieve data from.

 

Set correspondence between the source MS Access fields and the target SQL Server table fields:

  • select a field of the target SQL Server table in the Table 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 new table creation was selected at the previous step, then fields needed for the import procedure will be created automatically.

You can manage destination table fields if needed. Use the corresponded context menu item to New/Edit/Drop field.

 

menuEditField

 

Note: If table was properly created or already exists, it will be marked with a tick Tick. If an error occurs during table creation, this table will be marked with a cross .

 

If you choose a query as the data source, you also can load a SQL query from a *.sql file or save the current query text to a file using the Load from File... and the Save to File... buttons correspondingly.

 

Use the Auto Fill Columns button to set correspondence between the source and target fields automatically on the basis of their order.

 

Step 3 - Access

 

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 Setting base data formats step of the wizard.