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.