Append Query Results to CSV using automation?


I created an automation that loops through my query by date, incrementally. If I use excel, i am able to append the result from each loop to the same excel spreadsheet. Yea!
However, my data set is growing, and I now generate more than 1M records... so i would like to move my output to a CSV file. The first loop to the CVS file works great, but the subsequent loops fail because the file already exists. Is it possible to append the output stream so that all the data ends up in one CSV, like a can in excel? I can't see an "append" option, like i see with excel... am i missing something?

Thanks for any help!


No. There is no append for CSV. Excel gives us the ability to know where the last row is so we know where to append. CSV is just a file that does not have this feature.