How to connect Flat Text File

See more:

C#3.0

C#

I want to connect to Flat Text File by Oledb in C#.File have data delimated by ~(Tild)

I am using below connection String for Flat Text File By (Oledb) having Extension .PTS (File can be open in Notepad only extension is different).

I am getting Error

"Format of the initialization string does not conform to specification starting at index 62"

Connecting to a Text file using the JET OLE DB Provider:

strConnect = 
        _T("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\DatabasePath\\;"
        "Extended Properties=\"\"text;"
        "HDR=Yes;FMT=Delimited(~);\"\";");

Appreciate Your reply