welcome 123
asked on
Append data to CSV file
hello,
I have a client tool which exports data to csv file and everytime i refresh the data the csv file gets new data and delete the old data. I need data to be appended wth every refresh and how is hs possible?
Thanks,
Sailaja
I have a client tool which exports data to csv file and everytime i refresh the data the csv file gets new data and delete the old data. I need data to be appended wth every refresh and how is hs possible?
Thanks,
Sailaja
What is the tool? Is there a settings or parameters screen where you can choose different options?
Agreed, first choice would be to see if the tool has an "append" setting for the output file.
If not, then one way to work around this would be to rename the prior file (save it) before running the next export, and then use a BAT command or VBS script to merge the two files back together, combining the prior history with the new exported data.
~bp
If not, then one way to work around this would be to rename the prior file (save it) before running the next export, and then use a BAT command or VBS script to merge the two files back together, combining the prior history with the new exported data.
~bp
ASKER
yes the tool has no option.
Also can you help me with the vbs script on merging the two files please?
Also can you help me with the vbs script on merging the two files please?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.