[AccessD] Transfer text field name

Personally I would recommend getting rid of the # entirely.

John W. Colby 
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Doug Murphy
Sent: Thursday, April 01, 2004 3:07 PM
To: 'Access Developers discussion and problem solving'
Subject: [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








-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com