How do I modify the below clause to correctly read from an Excel worksheet in C#?
string queryString = "SELECT * FROM [#Ticker$]";
The pound sign in the FROM clause keeps getting converted to the temporary table "." symbol, giving me the following exception at runtime.
".Ticker$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long."
I need it to be a "#" as that is in the name of the worksheet. I have no control of the worksheet naming, so changing the name is not an option.