<div>
chr$(34) by the way is the quote (&quot;) and using it is one way to get a quote inside a string argument.<br />
<br />
Jim.
</div>


chr$(34) by the way is the quote (") and using it is one way to get a quote inside a string argument.

Jim.

<div>
Thanks to both of you!<br />
<br />
Kelvin, &nbsp;I never was able to get this to work with a comma delimited file, but can see how this solution will help in the future.<br />
<br />
Jim, you did it again! <br />
Thanks!
</div>


Thanks to both of you!

Kelvin,  I never was able to get this to work with a comma delimited file, but can see how this solution will help in the future.

Jim, you did it again!
Thanks!

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
My access application has a problem and the Export Specification wizard will not work. &nbsp;I don't have the original disk so I need to create a CSV file from a query programmatically.<br />
<br />
The column names of the query will change from time to time, but the name will not.<br />
<br />
Can anyone help?<br />
<br />
I guess I can use a maketable query then the recordset object to walk through the code, but I would think there should be a more straight forward approach. &nbsp;I tried using the recordset object to cycle through the query without any luck.<br />
<br />
This is a weekend project for me, so I need to get this code working today.<br />
<br />
Thanks.
</div>
</div>


Hello,

My access application has a problem and the Export Specification wizard will not work.  I don't have the original disk so I need to create a CSV file from a query programmatically.

The column names of the query will change from time to time, but the name will not.

Can anyone help?

I guess I can use a maketable query then the recordset object to walk through the code, but I would think there should be a more straight forward approach.  I tried using the recordset object to cycle through the query without any luck.

This is a weekend project for me, so I need to get this code working today.

Thanks.

Need to use VBA to create CSV comma delimited file for Access 2k

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.