Queries in Excel?

  • Thread starter Thread starter Dinesh
  • Start date Start date
D

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.
 
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.
 
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.
 
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.
 
Back
Top