Map the query fields
The way you map the fields from your script to your data file depends on the file type that you are using:
- Microsoft Excel
- Microsoft Access
- Text file
- SQL Server
- SharePoint list
Notes:
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.
