I am using C#.

I am trying to pull in a text file to an object. I am using an ODBC connection and it looks like this

Driver={Microsoft Text Driver (*.txt; *.csv)};
Dbq=C:\Users\Owner\Desktop\IR\IR_Files\Absolute;
Extensions=asc,csv,tab,txt;

I am able to make the connection but I can't get my columns separated. I'm using a schema.ini file but it isn't working. Here is my schema file.

[MyTextFile.CSV]
Format=Delimited(|)
ColNameHeader=False
Col1=fullstockn Text
col2=FULLINFO Text
MaxScanRows=0
CharacterSet=ANSI

The text file looks like this.

fullstockn|FULLINFO

"555555"|

Contenu : Neuf Ttudes sur l Some more text here.....