MS Query Replacement

[FeS2]

I am looking for a replacement to the built in MS Query that comes with Excel 2007.

In the company, we used to use Proclarity Live to run queries in excel and return the results, it was easy to use, worked very well with parameter queries. However, it doesn't work with office 2007, and the company is taking the Proclarity server offline.

Does anyone know of a good SQL Query add-in for Excel that works well with parameter queries? I have seen in these forums where people are using vba to form the sql and retreive parameters from cell locations. VBA coding is not on option for us.

Thanks for any help

 

[dham63]

I like Crystal Reports. You can demo it at

http://www.crystalreports.com

Dee

 

[Lilliabeth]

if you have sql server, then you aleady own SQL Reporting Services.

--Lilliabeth