Data Import into Excel

  • Thread starter Thread starter dhess62
  • Start date Start date
D

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
 
You need to move the data away after it has been populated. Consider using
an OnTime macro to automate this.
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I import data into Excel from Bloomberg using Excel 2007? 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import Multiple XML Files into Excel 3
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
import multiple excel books to one excel workbook 3
Excel web query does not import table (from yahoo finance) correct 2
Import External Data 3
A formula in this worksheet contains one or more invalid reference 1

Back
Top