CSV provider example connection strings
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.