Hi All,
I have a large SQL result set that I often need to dump to a CSV file. The request to dump this data to a CSV file is always different. Different clients want to see different columns of data, in different order, and some want to have column header and footers and some don't.
I was thinking of doing something with Config files so that I could just build a new config file with the CSV column specs and then pass that config file name as a parameter and then my CSV would be output.
Right now, I'm constantly adding new conditions to my program to accommodate every new request and this is obviously far from efficient.
Can anyone help me out with some suggestions and perhaps some samples to get me started? I want to build this the most efficient way possible so that virtually no code changes will be necessary.
Thx
Start Free Trial