View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dhess62 dhess62 is offline
external usenet poster
 
Posts: 3
Default 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