Exporting A Query containing a SWITCH function - unable....

[MissAran]

Hi There,



I have a Marco that outputs a CSV file. This Marco previously used a standard query. However, the client requested that depending on a result the column's value will be x, or, y etc etc.

So, I have the new query that contains a SWITCH function. The query runs fine via the "run" feature on Access and throughout the database.... except when I try to use the Marco to export. It always states:

"The Microsoft Office Access database engine could not find the object 'invoices.csv'. Make sure the object exists and that you spell its name and path name correctly."

Even though, if I take out the SWITCH function from the query it all works as expected.

So my question is, could someone please test this out for me that you can export to a csv file using a marco with using a switch function.

I just need to explain to the client that this can not happen... but a possible solution would also be fantastic!

Any help would be much appreciated.

[June7]

Works for me using VBA.

Docmd.TransferText acExportDelim, ,"Query1", "C:\Temp\Test1.csv"

[trevor40]

convert the macro to vba and post that,
also post the sql view of your query...