OK, so I’d actually ran into the quote issue before, with the header row. Having it as 1 field in the db static which I call at the start of each write, I was getting quotes around it.
So I gave up after a while of google’whacking and created a template.txt file with the header and had code to copy and rename that for every file, not very elegant. And, even with “ab” append binary, there was a blank row between the header row and the first row of proper data. I guess a way around it, which I’ll try tomorrow, is to have 32 static fields in its own table, each with the header value, that I call once at the file create stage.
But I’d like to know why this is?
When I output the file as CSV, open it in notepad, the quotes are there. When I then open it in Excel, the quotes aren’t there, and when I close the file it asks if I want to save it, which then removes the quotes permanently.
Any insight?