I have done this before, using a record that has the headers correctly named instead of the data, and then making sure it is the first record in the export. Exporting as CSV so it doesn't add the Real Header.
Not a refined solution, but did work.
This sounds a little bit easier than the other example. How did you set it up so that the headers?
Cause a few of the export fields I have are numbers so how could it handle text?
Yes number fields were a problem, it was a few years ago I did this., probably FM 7 ish time.
I think I had to create text versions of the number fields for this to work and copy the number fields with a calc into them and use those in the export.
It was dirty and messy, but at the time the headers had to be exactly named for the export.
@Beverly Link looks a much more elegant solution. though more complex to setup.
Ah thought so.
I'm exploring solutions at the minute for importing to sage so this would be quite a nice little fix as we do not know whether to just do a one way import to sage or explore an automated link.
Thanks for the help.