Link to home
Start Free TrialLog in
Avatar of welcome 123
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
Avatar of Member_2_933725
Member_2_933725

What is the tool? Is there a settings or parameters screen where you can choose different options?
Avatar of Bill Prew
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
Avatar of welcome 123

ASKER

yes the tool has no option.

Also can you help me with the vbs script on merging the two files please?
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial