In "How can I use a cell value to update my Command text using the OLE DB Query in Excel", there was a working solution that I am able to reproduce. However, there seems to be a limitation on this solution. What can we do to accept a cell value into an OLE DB Query when the query "Cannot be displayed graphically?
I've attempted to include the ? or [Question?] syntax into the query command text window, but it gives me the error "Table TABLENAME cannot be added".
To easily create a query that cannot be viewed graphically, I created a query like this against one of our tables: select column1, count(column2) from table1 where column3 = value group by column1
Thanks for your input.
Start Free Trial
