Quick yes/no answer - an easy one for all you gurus out there

[Alec M1BNK]

Hi All

Thanks for all the help with my problematic text export problem.

I export the text of a query as an Excel file thus
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8,
"q_SamUpload", [Forms]![f_FlatFileOut]![filename], True

I also output the same as tab delimited text file file for a different
purpose thus

DoCmd.TransferText acExportDelim, "samout_filespec", "q_SamUpload",
[Forms]![f_FlatFileOut]![filename2], False

Many of the fields in my query are numeric, and one is formatted with a
piece of text before the sequential number. This formatting is preserved in
the Excel file, but not in the text one.

Is there a way I can preserve the formatting in the text file too.

 

[John Vinson]

Is there a way I can preserve the formatting in the text file too.

By using the Format() function in a calculated field to recast the
number into the desired format.

John W. Vinson[MVP]