Export: DoCmd.TransferText

[Bud]

Hi all,

I'm using a the following function to export data from a query:

DoCmd.TransferText acExportDelim, "ExportSpec", strQryExport, FileName

The query builds an output string into a resultfield, but it only outputs about 266 characters on a single line in the resulting textfile "FileName"! But the string is longer in the query itself.

Any solutions?
Bud.

 

[namliam]

Yo probably mean 255, thats the longest it will export (as far as i know)

Sorry