VBA Excel Data SQL question

[thefox149]

I have been "ORDERED" to created an excel reporting tool

I have created many in access. However this time I must created it in excel

I basically want to query data in excel as I do in access eg queries etc.

I know I could create pivot tables but have been told not to those as well

Basically there should be a combobox that contains states
and it grabs the results (some form of vlookup) and graphs it

In Access this is easy but excel not go..

Can I query internal data in the SQL Query Analyizer?


My cat's name is sprinkles
-Ralph Wigam

 

[PHV]

In excel: menu Data -> External data -> ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

thefox149,

I often use the technique where I have a sheet where I query a table to select one distinct field to be used as a source for a combobox.

I set up my Chart as a New Sheet with Form Controls, since COntrol Toolbox Controls won't work on a Chart.

Then, Assign macro to your query procedure when you make a combobox selection, substituting the selected value in the SQL.

Skip,

_{[red]Be Advised![/red] Coeds studying ancient Egyptian plumbing, might be known as...
Pharaoh Faucet Majors}