Flat File Data Source

You can create a table from a flat file data source (such as *.csv).

Properties of the Flat File data source:

Source File Path

The file location

Example: \\file-server\share1\file.xlsx

Headers Row Structure

The row header (the name of the new table)

according to the structure of the file, for example: Users, Roles, Data

Delimiter Character

The delimiter separating entries

First row specifies a column name

Click to read the headers from the Excel sheet