Schema.ini is ignored

[Kris]

Hi,

i have another problem yet with |-seperated values:

i have my connection:

connCSV = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=C:\path;Extended Properties=""Text""")

and my schema.ini:

[test.txt]
Format=Delimited(|)


but i get one big field containing text like "name|phone|street|" and
so on.

yesterday it worked, today i juggled a little with the code and i don't
know what's wrong here!?

has anyone an idea, i'm going crazy on this!!!! :-(


thanks a lot

chris

 

[Paul Clement]

¤ Hi,
¤
¤ i have another problem yet with |-seperated values:
¤
¤ i have my connection:
¤
¤ connCSV = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
¤ Source=C:\path;Extended Properties=""Text""")
¤
¤ and my schema.ini:
¤
¤ [test.txt]
¤ Format=Delimited(|)
¤
¤
¤ but i get one big field containing text like "name|phone|street|" and
¤ so on.
¤
¤ yesterday it worked, today i juggled a little with the code and i don't
¤ know what's wrong here!?
¤
¤ has anyone an idea, i'm going crazy on this!!!! :-(

Assuming the schema.ini is in the same folder as the files (c:\path in your example) I don't see any
issues, although I generally specify at least the following entries:

[Test.csv]
ColNameHeader=True
CharacterSet=ANSI
Format=Delimited(|)


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Kris]

hmmm...

after you found no issue i've isolated the code in a new project and
put the datafile into an new folder, now it works.

there must be a bug or peace of code in the project wich doesn't belong
there. anyways, i'm glad that it works an i'm shure to find out what it
is...

thanks for your help

chris