<div>
Thank you. &nbsp;Works great. &nbsp;
</div>


<div>
<div class="content wysiwyg-content">
Hi experts,<br />
<br />
My client would like me to export the results of a query to tab delimited text without quotes. &nbsp;<br />
<br />
I have tried the code:<br />
<br />
DoCmd.TransferText acExportDelim, , &quot;qryProductDirectoryExport<wbr />UpdateNewF<wbr />inal2&quot;, &quot;C:\ProductDirectory.txt&quot;,<wbr /> True<br />
<br />
...but I get a result that includes quotes and commas. &nbsp;Any ideas? &nbsp;<br />
<br />
I would appreciate any help. &nbsp;Thanks!<br />
&nbsp; &nbsp; 
</div>
</div>


Hi experts,

My client would like me to export the results of a query to tab delimited text without quotes.  

I have tried the code:

DoCmd.TransferText acExportDelim, , "qryProductDirectoryExportUpdateNewFinal2", "C:\ProductDirectory.txt", True

...but I get a result that includes quotes and commas.  Any ideas?  

I would appreciate any help.  Thanks!
    

Access 2002 - Export to tab delimited text without quotes

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.