| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Import into Excel
I have the data import set up in excel, I have it set up to import via an SQL
query once evey 24 hours. My Question is: How can I have excel populate my spreadsheet each time the query runs without over writing the data from the previous import? I want to keep the data from each days import on a new row so I can see historical data as it accumulates. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Import into Excel
You need to move the data away after it has been populated. Consider using
an OnTime macro to automate this. -- Gary''s Student - gsnu200839 "dhess62" wrote: I have the data import set up in excel, I have it set up to import via an SQL query once evey 24 hours. My Question is: How can I have excel populate my spreadsheet each time the query runs without over writing the data from the previous import? I want to keep the data from each days import on a new row so I can see historical data as it accumulates. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Import into Excel
OK, I'm not familiar with the On Time Macro, I went to help and it didn't
list anything either. Do you have any more specific information on how I can do this? "Gary''s Student" wrote: You need to move the data away after it has been populated. Consider using an OnTime macro to automate this. -- Gary''s Student - gsnu200839 "dhess62" wrote: I have the data import set up in excel, I have it set up to import via an SQL query once evey 24 hours. My Question is: How can I have excel populate my spreadsheet each time the query runs without over writing the data from the previous import? I want to keep the data from each days import on a new row so I can see historical data as it accumulates. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Import into Excel
I found a site that explains the OnTime process
http://www.ozgrid.com/Excel/run-macro-on-time.htm "dhess62" wrote: I have the data import set up in excel, I have it set up to import via an SQL query once evey 24 hours. My Question is: How can I have excel populate my spreadsheet each time the query runs without over writing the data from the previous import? I want to keep the data from each days import on a new row so I can see historical data as it accumulates. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import XML data...Is there a size limit on the import? | Excel Discussion (Misc queries) | |||
| import excel data | Excel Discussion (Misc queries) | |||
| How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
| Import external data, data includes Excel function | Excel Worksheet Functions | |||
| how to Import data in excel office2003 with data more 65000 rows | Excel Worksheet Functions | |||
Linear Mode
