Hi PEB,

The data needs to go into a comma delimited file, but different rows have a different structure, therefore the function creates the correct structure and exports a single column table in the correct order. This single column has been truncated. The full version of the first few rows is shown below.

PRCG,AreaAp8,27-Aug-06,156126.99,M2 53, ,20060827, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,...

When using the command:

DoCmd.OutputTo acOutputFunctio n, "SQLfunctioncal l", acFormatTXT, "filename"

The results are truncated as shown below:

---------------------
| Data |
---------------------
| PRCG,AreaAp8,27-A |
---------------------
| PRQT,MALL003386 ,0 |

Results are also not truncated when output to Excel or when the...