View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ondori44@hotmail.com is offline
external usenet poster
 
Posts: 1
Default 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