Include special characters in export (1 Viewer)

[tabitha]

I'm trying to export either a report or a query to excel with a field name that has special characters "()". I wouldn't normally ever do this (everyone knows not to use special characters) but we're using this to import the excel document to a website, and the field name MUST be what they specified in order for the import to be successful. Is there any way to rename the field name at export, since I can't use special characters on the query or report itself?

The field name is currently DepType, but it must be
"
*Dependent Type
Spouse/Partner or Child/Dependent
(Required for Dependents only)
"
EXACTLY or it will not import. (ridiculous, I know)

 

[tabitha]

Nevermind, I realized that it wasn't the parentheses that was the problem, it was the character length. I trimmed it to exactly 64 characters and it was successful.