I'm using the SQLExecQuery command to pull data from my database. But I want to use a cell within the Excel worksheet as part of the query.
ie.
"SELECT CLIENTS.NAME FROM DATA.CLIENTS WHERE CLIENTS.CLIENT_ID = ??"
Where ??, I'd like to reference cell B4.
Is this possible?
What's the formula?
Thanks
ie.
"SELECT CLIENTS.NAME FROM DATA.CLIENTS WHERE CLIENTS.CLIENT_ID = ??"
Where ??, I'd like to reference cell B4.
Is this possible?
What's the formula?
Thanks