link excel with query to SQL databases

[mat.j]

Hi,
Im new to his forum and exel. I recently discovered that you can automate things in excel.
I have the following problem. There's 2 huge databases on a mirosoft SQL server. The databases consists of points being logged every second. Every week I need to make a report of the past week. Those points need to be averaged over an hour for that. I managed to write a query that takes out the data of one of the databases and puts it in excel.
Is there a way to have a sheet in excel where you fill in the dates "from ... to ..." and that you then get the data of one database on sheet 2 and the other database on sheet 3?
kind regards

[Kiran.Sunkara]

Hi Mat, welcome to the forum.
Please go through the below link:
http://www.ozgrid.com/forum/showthread.php?t=83016