<div>
Right click on the table <br />
export<br />
text file<br />
select file name and say ok<br />
advanced<br />
text qualifier {none}<br />
<br />
follow the rest of the process for export<br />
<br />
Ss<br />

</div>


Right click on the table
export
text file
select file name and say ok
advanced
text qualifier {none}

follow the rest of the process for export

Ss


<div>
thanks sshah.... &nbsp;is there a way to do this in a macro or vba so the user can do it by pressing a button in the app without all the extra steps?<br />
<br />
thanks again.
</div>


thanks sshah....  is there a way to do this in a macro or vba so the user can do it by pressing a button in the app without all the extra steps?

thanks again.

<div>
<div class="content wysiwyg-content">
I'm working on a small app in access 2007.... &nbsp;I need to export records from a table to a csv, but without the double quotes around the strings... &nbsp; can anyone give me an idea of how to do this??<br />
<br />
thanks<br />
randy
</div>
</div>


I'm working on a small app in access 2007....  I need to export records from a table to a csv, but without the double quotes around the strings...   can anyone give me an idea of how to do this??

thanks
randy

Export Access 2007 Table to CSV

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.