Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lost "Mailing" tab across top of Excel - Need to do e-mail merger | Excel Discussion (Misc queries) | |||
Could you help with launching Mail Merger with a code from within Excel? | Excel Discussion (Misc queries) | |||
Excel merger | Excel Discussion (Misc queries) | |||
mail merger in excel | Excel Discussion (Misc queries) | |||
mail merger in Excel | Excel Discussion (Misc queries) |