C
cm
I need to export a query (to excel format) for use in uploading data to a
system. That system requires specific column headers on the upload file.
One of the column headers needs to be: File # (no quotes)
The data in the query field is File #: Right([datafield],6). The displayed
header is fine, but when exporting, the # symbol is replaced with a period.
I tried converting it in sql using cstr(), however that resulted in a column
header of "File ." (including the quotes).
Does anyone have any suggestions on how to remedy this?
system. That system requires specific column headers on the upload file.
One of the column headers needs to be: File # (no quotes)
The data in the query field is File #: Right([datafield],6). The displayed
header is fine, but when exporting, the # symbol is replaced with a period.
I tried converting it in sql using cstr(), however that resulted in a column
header of "File ." (including the quotes).
Does anyone have any suggestions on how to remedy this?