Data Import into Excel

[dhess62]

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

 

[Gary''s Student]

You need to move the data away after it has been populated. Consider using
an OnTime macro to automate this.

 

[dhess62]

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?

 

[dhess62]

I found a site that explains the OnTime process
http://www.ozgrid.com/Excel/run-macro-on-time.htm