Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error While reading a csv file using schema.ini

Status
Not open for further replies.

ganusha

Programmer
May 1, 2002
28
US
Hi,
I'm reading a .csv file and it is actually semicolon delimited. I created the schema.ini and am trying to read the file using ado and microsoft text driver. It works fine except when i come across a field with double quotes it gets it with double double quotes.
eg if the field is Box 19", the field in the recordset reads as Box 19"" and it reads all the fields in the line with double quotes.

My schema.ini is as follows

[203045_20040329042755_100002.CSV]
TextDelimiter='
ColNameHeader=False
Format=Delimited(;)
Col1=F1 Text
Col2=F2 Text
Col3=F3 Text
Col4=F4 Text
Col5=F5 Text
Col6=F6 Text
Col7=F7 Text
Col8=F8 Text
Col9=F9 Text
Col10=F10 Text
Col11=F11 Text
Col12=F12 Text
Col13=F13 Text
Col14=F14 Text
Col15=F15 Text
Col16=F16 Text
Col17=F17 Text
Col18=F18 Text
Col19=F19 Text
Col20=F20 Text
Col21=F21 Text
Col22=F22 Text
Col23=F23 Text
Col24=F24 Text

Please help, Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top