*.csv file question

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Question :
I have *.csv file that contains data I would like to chart
using MS Excel . The data in the *.csv file is updated by
another window every minute for a period of 7 hours.
If I load the *.csv file into Excel my chart will be current
for only one minute. Is it possible to reload the same *.csv
file one minute later and have an updated chart and will this
present a possible conflict with the other window if I load
the file at the same time the other window is updating the data ?
 
Have a look at getting External Data and creating a query.
The data could then be updated with a requery every minute.

Conflicting with your other programme would depend on whether or not your
other programme opened the csv exclusively.
 
Back
Top