How can I deal with a large number of data?
 

Hi
I need to design a system to collect large numbers of data, and display them
in Excel's chart for further processing.
But the Speed of collecting is so fast that I can not put the real-time data
into excel for charting them in time.

Can I do it in this way:
step 1: collecting the data into a Access database,
step 2: then every a few seconds, reading certain numbers of data into
Excel, and displaying them in a chart.

All the two steps need to be done in Excel VBA. I have finished the task of
collecting data, and I have two questions about the step 2.
1. can the data in the database be read into Excel while other collecting
data need to be written into the same database.
2. Whether the data source of a chart must be some cells in a Sheet, Can I
use the records of the Access database directly as the data source without
writing them into cells.

thanks!