*.csv file question

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 ?
 
M

martin W

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.
 

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

Top