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

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

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

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