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=True;Comment Prefix='';
Column Type=String,String,String,Int32,Boolean,String,String;Trim Spaces=False;
Ignore Empty Lines=True;

"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.