Map the query fields
- Microsoft Excel
- Microsoft Access
- Text file
- SQL Server
- SharePoint list
The account that you use to write to SQL Server must have db_owner or db_ddladmin membership on the database that contains the target table.
If you are using XML forms for the data file, you do not need to map the fields.
Note: In the Mapper, you can use the keyboard shortcuts CTRL Z (undo a command) and CTRL F (find a word or words, as in the screenshot below).
In Query, users can Shift Up and Shift Down multiple rows at a time within the Mapper.