ODBC text driver

I am currently using Microsoft text driver in VB code to read from a tab, comma delimeted sytle file. This works OK until some entries contain double quotes in which case it strips everything after the quotes. In the default on the PC I am testing the defaults are as follows:
File Type: ANSI
Row delimiter: {CR}{LF}
Text qualifier: Double quote{"}
I have tried using the schema.ini file also but there is still a problem so I need to use the ODBC text drivers. Any sample of code on how to do this would be helpful.
Thanks.
bccAsked:
Who is Participating?
 
Richie_SimonettiIT OperationsCommented:
I can access the files before processing, if you cannot do it my advise doesn't help you. I did it in the way i have commented out.
Sorry.
0
 
Richie_SimonettiIT OperationsCommented:
That's was a problem to me to too. If you could access the files before processing, open each on with open statement, save the contents to a variable, replace every instance of double quotes (with Replace funtion) and open the file for output and write back the content of variable to file.
0
 
bccAuthor Commented:
Thanks Richie but that's not really a solution to my problem, is it? If you have already worked out a way to do this I would like to know it please.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.