[AccessD] Transfer text field name

Folks,

I am outputting the results of a query into a comma delimited text file
using the transfer text method. Field names are to be put in the first
row. Some of the query fields use assigned names, e.g., Street
#:[fldStreetNo].  The interesting thing is that the "#" in the field
name shows up in the query when the results are viewed but shows up as a
"." when I look at the text file. I put the symbols in quotes they are
not part of the output.  Any one have a suggestion on how to get
transfer text to put the "#" where it is supposed to be?

Thanks

Doug