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

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


This connection string (Standard using txtReader) can be used for connections to Textfile.

Articlesread all »

Not the right connection string for you?

Start over in the connection string reference index.

You can also get help in the Q&A forums where you can ask your own question.

The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.