G
Guest
do have two sets of files
1. abc.csv,xyz.csv,pqr.csv....till n (Master files); format as below:
Date Price
02-11-07 168
01-11-07 165
2. Trans.xls; format as below:
File Date Price
abc.csv 02-11-07 169
xyz.csv 02-11-07 251
Now i want as follows:
abc/xyz/pqr.csv is updated from trans.xls everytime i run the code. it must
look whether data relevant to "Date" exist or not? If Exist write over it and
save & close the .csv files; if not exist insert a line after first row and
put the data there.
Both file have different directory. i can put both files in same directory.
Any help would be greatly appreciated...
1. abc.csv,xyz.csv,pqr.csv....till n (Master files); format as below:
Date Price
02-11-07 168
01-11-07 165
2. Trans.xls; format as below:
File Date Price
abc.csv 02-11-07 169
xyz.csv 02-11-07 251
Now i want as follows:
abc/xyz/pqr.csv is updated from trans.xls everytime i run the code. it must
look whether data relevant to "Date" exist or not? If Exist write over it and
save & close the .csv files; if not exist insert a line after first row and
put the data there.
Both file have different directory. i can put both files in same directory.
Any help would be greatly appreciated...