View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
karthik karthik is offline
external usenet poster
 
Posts: 48
Default Merger SQL Query into EXCEL

I run a SQL query daily in server and extract data from the table. A .CSV
file is generated every time i run a query and I manually copy the data from
the .CSV file and paste it in an excel template sheet for further analysis.
Could anyone please let me know a formula or a Macro that could run the query
and paste(import) the data directly in to the template on daily basis.

The query would have a date range which i manually change daily before
running the query. Could this be automated in an excel sheet?

Thanks for your help in advance.
--
Karthi