[RESOLVED] connection string to .CSV

[Amien]

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path & ";Extended Properties=""text;HDR=No;FMT=Delimited( ; )"""

i see data .. but the seperation by semicolon is not working .. what do i need to change?

(extra spaces for ; .. cause of smilies)

[stanav]

Do you mean that you file is actually semi-colon delimited instead of comma?

[Amien]

yes .. my file has a semi-colon in it ( ; )

[dminder]

Have you tried this?

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path & ";Extended Properties=""text;HDR=Yes;FMT=Delimited;"""

I am not sure if you are aware of this site or not:
http://www.connectionstrings.com/textfile

Good Luck and hope this helps!

D

[Amien]

yes .. tried it .. not working

when i change the layout from ; to , .. then its working .. but i really need a ; and not a ,

[Amien]

found it ..

need to create a schema.ini file .. on the same location .. containting:

[test.CSV]
ColNameHeader=False
CharacterSet=ANSI
Format=Delimited( ; )

[dminder]

Cool, good job! Where did you find that info? And dont forget to mark the issue resolved!!

D

[stanav]

Don't use ADO.Net in your case then. With ADO.Net, it uses the system's default delimiter and unless you've changed it, that default delimiter is the comma. You can change it in registry, but I strongly suggest that you DON'T do it. You can also create a schema for the file, but it needs to be in the same folder as the file, and if you have many of those delimited files to parse, it's going to be very tedious to create the schemas for them all.
Instead, have a look at the TextFieldParser class which you can set its Delimiters property to tell the object what the delimiters are in the file.

[Amien]

found it on google somewhere .. i thought .. this is never gonna work .. but i was kind of desperate

Thanks for the tip stanav .. might look into that TextFieldParser..