Export Temporary SQL Table to CSV

[Robert Robichaud]

I've created a global, temporary table in SQL (called ##myTempTable) via a
Stored Procedure and wish
to export its content to a .CSV file. After the
Stored Procedure is executed, I try to execute the following:

DoCmd.TransferText acExportDelim, , "##myTempTable", strFileName, True

I get a run-time error of 7874. I can display the contents of ##myTempTable
in
Query Analyzer. I need the results in this table to be automatically
exported to a .CSV file.

Any ideas?

Thanking you in advance.

 

[BJ Freeman]

unless something has changed you can export to a CSV file directly.
you will get a text file with | delimiters.
you have to actually write a CSV export routine.