daniel_d_n_r
08-30-2007, 02:37 PM
Hi all
Just a query here,
At the moment I havn't started coding but would like an opinion on the best way to go about this task ..as follows.
I have 8 text files that hold data
This data is added to every few days by a program that appends data to the existing file
I would like to import all the data into one excel workbook and the have the data linked to charts that will display the data (the feilds do not change) and they update themselves on import.
one main problem is dealing with the CSV (.dat) files and parsing or ignoring the meta data/headers in the first 2 or 3 rows.
after the headers the data is set out as csv data with columns and headings
any ideas would be appreciated
cheers
Just a query here,
At the moment I havn't started coding but would like an opinion on the best way to go about this task ..as follows.
I have 8 text files that hold data
This data is added to every few days by a program that appends data to the existing file
I would like to import all the data into one excel workbook and the have the data linked to charts that will display the data (the feilds do not change) and they update themselves on import.
one main problem is dealing with the CSV (.dat) files and parsing or ignoring the meta data/headers in the first 2 or 3 rows.
after the headers the data is set out as csv data with columns and headings
any ideas would be appreciated
cheers