Data Import into Excel

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
 
G

Gary''s Student

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

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?
 

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
Import more than one .csv file into the same Excel file. 1
Excel web query does not import table (from yahoo finance) correct 2
Where is the Data Import Excel button in Excel 2007 6
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
Import Data from Access query 8

Top