Queries in Excel?

[Dinesh]

Hi there:

Is there a way to create and execute queries in Excel? I
don't think there is, but I just wanted to get a consensus
on this. Your help is greatly appreciated.

Regards,

Dinesh.

 

[Jake Marx]

Hi Dinesh,

What type of queries are you asking about? You can create and execute web
queries and database queries via Data | Import External Data. You can also
use VBA to connect to a database or website using ADO or the Internet
Controls.

 

[Don Guillett]

multi asked

 

[Dinesh]

Hi Jake:

Thanks for your reply. I'm trying to find out in Excel
how to run SELECT statements that will generate a report,
based on the information extracted from that query. Hope
that made sense. If there is any added info you can
provide, it would be greatly appreciated. Thanks again
for your help.

Regards,

Dinesh.

 

[Jake Marx]

Hi Dinesh,

Did you check out the Data menu in Excel? This may be enough to get you
started. If you have a more dynamic query, you may have to do it in ADO and
return the recordset to Excel. There are many online sources that give
examples of using ADO from Excel (or VB for that matter). Once you get the
data in your recordset, you can use the CopyFromRecordset method of the
Range object to put the data into Excel.