Microsoft.Jet.OLEDB.4.0 Extended Properties
Posted on 2006-06-30
I am trying to read a delimted file using this as a connection String:
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strFilePath & ";" & _
I have setup a Schemi.ini file to specify my delimiter.
This code works perfect if I create the text file from MSAccess. If I create the file using the .NET streamWriter using UTF8Encoding the
property does not work. I have tried using UTF7Encoding and UTF32Encoding.
Is there a way to specify in the Extended properties which encoding to use? OR is there a different way to write the file that will be compatible with
the jet.oledb.4.0 connection string?