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
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