VBA Output Creates Headers with Question Marks

[liammoohan]

Below is a screenshot of the module I have created which uses a query result to create a CSV file with the data in; the problem I have is that the first column header is always created with a question mark i.e. ?ACCOUNTNUMBER

Is there any reason why or how can I stop this from happening?

Thanks

 

[Micron]

Methinks it might be because there is a leading non-transferable character (e.g. degrees character) or a space that's being included in the header value. Anything like that in your query results? I presume the question mark does not show up anywhere in your query results. There are no hyperlink values involved?

 

[Joe4]

Methinks it might be because there is a leading non-transferable character (e.g. degrees character) or a space that's being included in the header value. Anything like that in your query results? I presume the question mark does not show up anywhere in your query results. There are no hyperlink values involved?

It was a long time ago, and I don't know what application was creating it, but I do recall seeing the behavior that they are describing. And it wasn't anything special in the headers or data.
The first space of the entire CSV file would have a question mark (so it would be on the first line in the first space). So it would look something like this:

?Field1,Field2,Field3,
a,b,c,
de,f,
x,y,z,

I wish I could remember the situation in which I saw it!
I don't know if it was something like a "print contol character" or something to that effect.

liam,
Are you experiencing something like that example output I showed?
Could you possibly do a screen print of the first few rows of your query results (being sure to show us the field names)?

 

[james_lankford]

byte order mark ?

Byte Order Marker

The Unicode standard - Globalization

Learn about the Unicode Standard that supports all historical and modern writing systems with a single character encoding

docs.microsoft.com