Help: Creating dynamic sql queries in excel
Here is a question, and thank you in advance for taking the time to
read and help.
I have an Excel Spreadsheet that I need to auto-populate depending on
the PurchaseOrder number that a user types in.
So PONumber: <Cell here
and that cell's data needs to be the where clause of my sql statement.
When the user enters in the value, the query is executed and popluates
the sheet with the need information in the give places.
I have tried to link in the query with Data-Import External Data-New
Data source and New Data Query. The wizard seems to ask for static
queries, and formatting the data that I query is not to flexable.
Help me out here.
Thanks again.
-Rooster
|