Export query to CSV

[daniel.preda]

I have a query with 4 columns (one invisible - for criteria filtering purposes - criteria is a variable I have to define - inputbox - every time I run the query). The query is created in sql-view using "UNION"



When I try to export the three columns in CSV format (I need this format for a transffer to another software) it's saying something like:
"Too few parameters. Expected 1."
I would also like the export to be done through a macro (a button in a form) and without header row... so a VBA code would be perfect...

Please... can anyone help?

[ajetrumpet]

I have a query with 4 columns (one invisible - for criteria filtering purposes

that is most likely the reason then. I doubt you can export with a popup parameter like that. could you a form or something and substitute a form-referenced field into the WHERE clause where you now have the popup parameter? that would, for one, would enable the exporting via whatever method you choose.

[daniel.preda]

I've created a form.
Now the criteria is taken out from this form... no popup/inputbox anymore...
The same error...

[daniel.preda]

Funny thing...

I only have the error if I try File->Export->*.CSV

I tried with a code and it works perfectly:

DoCmd.TransferText TransferType:=acExportDelim, _
TableName:="my query", FileName:="c:\test.csv"