Select records 'INTO' text file

P

Paul

I'd like to automatically dump my query results into a text file (including
column headers).

Anyone know a way I can accomplish this?

Thanks!
 
A

Allen Browne

Try using the TransferText action to export your query.
There is an option to include the field names.
 
P

Paul

Well, I'm not good in VB at all - really. So, that being said.....I assume
there is no way to do this just via the query, as if I were selecting records
and using the INTO command to write them to a table, only writing them to a
text file?

Here's basically what I'm doing and the results I want to be automatically
exported...

Select <field1>, <field2>, <field3>, <field4>
From <table>
Where <field2> Between '<x>' and '<y>'
And <field4> In('<criteria1>', '<criteria2.'>)
 
A

Allen Browne

1. Save the query.
2. Create a new marco.
3. Choose the TransferText action.
4. In the lower pane in macro design, fill in the lines.
5. Save the macro.
 
J

John Vinson

Well, I'm not good in VB at all - really. So, that being said.....I assume
there is no way to do this just via the query, as if I were selecting records
and using the INTO command to write them to a table, only writing them to a
text file?
Click to expand...

You don't really need VBA code (though it's NOT hard in this
instance); you can use a Macro to export a saved Query to a text file.
As Allen suggests, the TransferText action is the key; see the online
help for it, and call it from either a macro or from code.

You cannot do it in a simple Query. The query language simply does not
include that as an option.

John W. Vinson[MVP]
 
P

Paul

Thanks, that worked great!

Allen Browne said:
1. Save the query.
2. Create a new marco.
3. Choose the TransferText action.
4. In the lower pane in macro design, fill in the lines.
5. Save the macro.
Click to expand...
 
Top