The following dialog box displays a preview of the dataset to import. You can specify the name of the table to create in the database.
Team Studio determines the delimiter used in the file and the data type of each column. You can override the recommendation if necessary.
Selecting Show additional formatting options allows you to choose the delimiter, escape character, and quote character. Additionally, you can specify whether the uploaded file contains a header row and filter columns/empty values.
For each column, you can specify the name and data type, as well as options in the additional formatting options.
Note: To be imported as date, columns must be of the format "yyyy-mm-dd." To be imported as datetime, columns must be of the format "yyyy-[m]m-[d]d hh:mm:ss[.f...]". (Values in brackets are optional.)