CSV provider example connection strings
Custom delimiter
Let's assume that we want to connect to a CSV file that:
- has a header,
- is delimited by semicolon character ";"
The following connection string can be used:
DataSource=[ServerName]; IncludeFiles="CSV"; FMT="Delimited(;)"; HDR="Yes";
For different delimiter change the 'FMT="Delimited(_put_your_delimited_here_)"
property and replace the placeholder put_your_delimited_here with your desired character.