Queries in Excel?
 

Hi the

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.

Queries in Excel?
 

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.

--
Regards,

Jake Marx
MS MVP - Excel


Dinesh wrote:
Hi the

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.

Queries in Excel?
 

multi asked

"Dinesh" wrote in message
...
Hi the

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.

Queries in Excel?
 

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.


-----Original Message-----
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.

--
Regards,

Jake Marx
MS MVP - Excel


Dinesh wrote:
Hi the

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.

.

Queries in Excel?
 

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.

--
Regards,

Jake Marx
MS MVP - Excel

Dinesh wrote:
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.


-----Original Message-----
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.

--
Regards,

Jake Marx
MS MVP - Excel


Dinesh wrote:
Hi the

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.

.