Exporting a query in a comma delimited file (1 Viewer)

adj

Registered User.
Local time
Today, 21:23
Joined
May 23, 2000
Messages
14
I have a cross tab query that I want to export into a .Cvs file. I want to know how to do this with a macro. How can I tell access 97, to export this query to this file.
Please help.
Anne
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 16:23
Joined
Feb 19, 2002
Messages
43,371
You can use the TransferText Action. Just specify the query rather than a table name.
 

adj

Registered User.
Local time
Today, 21:23
Joined
May 23, 2000
Messages
14
It is a crosstab query.
 

Users who are viewing this thread

Top Bottom