<div>
Sure it works on queries. &nbsp;have you tried?<br />

</div>


Sure it works on queries.  have you tried?


<div>
Yes I tried, I get and error from the transfertext function, if I name a query instead of a table I get this error:<br />
<br />
I got a Run Time Error '2495'<br />
<br />
The Action or Method requires a Table Name argument<br />
<br />

</div>


Yes I tried, I get and error from the transfertext function, if I name a query instead of a table I get this error:

I got a Run Time Error '2495'

The Action or Method requires a Table Name argument



<div>
I dont have a space in the query name, but I didnt have the query name in quotes (&quot;&quot;) I didnt think you needed them when there werent spaces, but now its working, thanks for the reminder.<br />
<br />
R
</div>


I dont have a space in the query name, but I didnt have the query name in quotes ("") I didnt think you needed them when there werent spaces, but now its working, thanks for the reminder.

R

<div>
Glad to help. &nbsp;(On my way to the next level.) 
</div>


Glad to help.  (On my way to the next level.)

<div>
<div class="content wysiwyg-content">
I need to end up with a csv file that can be used for import and export from one program into another.<br />
<br />
I have an access database that reads the data from one program via odbc, massages it and preps it for export into the second program.<br />
<br />
there is a query that orders the data for presentation and its the query results that need to end up as the csv file.<br />
<br />
I found transfertext, but that only works on tables, not query results. &nbsp;the table is all text and doesnt export in the correct order. &nbsp;so I added a query to sort the data.<br />
<br />
Any hints?<br />
<br />
ACCESS 07 is the version<br />
<br />

</div>
</div>


I need to end up with a csv file that can be used for import and export from one program into another.

I have an access database that reads the data from one program via odbc, massages it and preps it for export into the second program.

there is a query that orders the data for presentation and its the query results that need to end up as the csv file.

I found transfertext, but that only works on tables, not query results.  the table is all text and doesnt export in the correct order.  so I added a query to sort the data.

Any hints?

ACCESS 07 is the version



how to export query results to a .csv file

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.