Standard using txtReader

Connection string

This .NET txtReader for Text Files connection string can be used for connections to Textfile.

Data Source='C:\MyFolder';Delimiter=',';Has Quotes=True;Skip Rows=0;
Has Header
Comment Prefix='';
Column Type
Trim Spaces=False;
Ignore Empty Lines

"Comment Prefix" means that if a line in the text file starts with the provided prefix value the whole line will be treated as a comment and will not be read.