<div>
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.
</div>


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.

<div>
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
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:<br />
File Type: ANSI<br />
Row delimiter: {CR}{LF}<br />
Text qualifier: Double quote{&quot;}<br />
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.<br />
Thanks.
</div>
</div>


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.

ODBC text driver

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.