Hi!
I'm trying to read text file like...
"Field1";"Field2";"Field3";"Field4"
"ABCD";"EFGH";"1234";"20051020"
"AABB";"CCDD";"2468";"20051021"
"CCDD";"XXYY";"4321";"20051022"
....using OLE DB-provider. Unfortunately I can't affect in what kind of
form this file is saved :(
I don't know how to make ConnectionString for this kind of file?
I think it should be something like...
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & myFileName &
";Extended Properties='Text;HDR=YES;...'"
....but how to specify in ConnectionString the fields are separated with
";" ?
--
Thanks in advance!
Mika