Excel Export with Special Character in Column Name -
04-24-2006
, 02:24 PM
Hello,
When exporting to an Excel spreadsheet, is it possible to use a character
such as # in the name of an Excel column. For example, I would like the
column for apartment number to be called 'Apt #'.
When I look at the Transformation Task properties, the column name appears
exactly as I want it. However, when the spreadsheet is created the # is
replaced with a period, so it appears as 'Apt .'
Thanks |