Export Temporary SQL Table to CSV

  • Thread starter Thread starter Robert Robichaud
  • Start date Start date
R

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.
 
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.
 
Back
Top