Gonzo TechNet - ADO.NET text file ConnectionString Extended Properties

ProjectSMM.com

Gonzo TechNet

ADO.NET text file ConnectionString Extended Properties

A few hints before we start,

The list of "Extended Properties" is a continuous string and must be contained within quotes. Single or double, its up to you. BUT, some of them may have quoted values so you may need to escape them, or get creative.
The FIRST value in the Extended Properties "string" MUST be the key-word: text
The "name=value" pairs must be followed by a semi-colon: FMT=Delimited;HDR=YES;
This is NOT a "complete" list. I'll add to it if/when I find more (and have the time.)

Example ADO.NET/VB.NET ConnectionString for Text files with extended properities:

cnStr="Provider=Microsoft.Jet.OLEDB.4.0;" & _
	"Data Source=" & sPath + ";" & _
	"Extended Properties='text;HDR=YES;FMT=CSVDelimited;'; "

cnStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDir;Extended Properties='text;HDR=YES;FMT=CSVDelimited;'; "

As an alternative, you can specify a "schema.ini" file. But, that is waaaaaaaaay beyond what I'm trying to accomplish here... (Good luck)

Property Name	Description	Value(s)
Provider	Name of provider. Since ADO.NET doesn't have one inherantly, use OleDB.	Microsoft.Jet.OLEDB.4.0
FMT	File is "formatted" using a specific style or delimiter	Delimited Each field of the file is "delimited". The default is a comma (,) Delimited(x) Each field of the file is "delimited" by the value within the parentheses. Example of using a pipe charater: Delimited(\|). CSVDelimited Each record/row in he file is formatted using QUOTED/Comma separated values. Ex: "Bob","Johnson","123 anystreet" TabDelimited Each field in each record of the file is separated by a TAB character. Ex: bobJohnson123 AnyStreetMy TownNew York
HDR	The first row in the file is the "Header". It contains the names of the fields/columns	YES It DOES have a header row NO It does NOT have a header row

© Gonzo TechNet is a wholely owned subsidiary of Fly-By-Night LLC, a divison of Charge-A-Lot Consulting, hosted by ©Projectsmm.com
With many thanks to Scott M. McNair and numerous others too ashamed to allow their names to be mentioned.