Export to Excel Query
Is there a specific query format to convert characters to numbers before exporting? I am having trouble converting in excel using vba. Any help is greatly appreciated.
Re: Export to Excel Query
Not sure exactly what you're trying to achieve.
In excel you can use the CHAR() function.
Example (just copy and paste this into a cell in Excel and select [ENTER]):
="Exchange Rates Graph of Pound (" & CHAR(163) & "), Euro (" & CHAR(128) & ") and Dollar (" & (CHAR(36) & ")")
It will return:
Exchange Rates Graph of Pound (£), Euro (€) and Dollar ($)
And if you need to know what CHAR is for a specific value you can use CODE() function.