I am trying to consolidate the daily .csv files from the compactflash memory card into a monthly excel or access file format.
I have 5 different .csv files for each day, all enclosed in a monthly folder inside the yearly folder.
I would like to separate the 5 types of files into 5 databases and list the records on daily lines with the totals at the base of the fields.
I have Excel and Access, but haven't done much data work since DOS and DBase days...
Any help or suggestions would be appreciated.
Thanks
Pat