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

G

Guest

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.
 
J

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top