Excel/MS Query: remove apostophe from header text

[romeovoid]

Good day, I have used MSQuery to return data to an Excel worksheet. Unfortunately, the header text is placed between apostrophes, as in, 'First Name'.

While I understand, that this may due to the header text being comprised of 2 words, i.e., having a [space] in the header text, do you know of any way I can suppress this when results are returned from MSQuery?

Yes, I know that I can perform a replace/find on the worksheet to rid myself of the apostrophes, but I was hoping that there was some configuration that I could set to effect this change. Thank you - R.

 

[SkipVought]

Hi,

I assume that this query is a recurring task.

If so, you ought to perform the query in a macro. I did this for all my production queries in Excel. In addition to the code for the query, you can also perform the Find ‘n’ Replace.

If you need help coding a solution, please start a thread in Forum707.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]