I need to export data from my dataset (containing two tables is a parent child relationship) to Excel.
I could export it as a CSV file. Can I get column headers in Excel when importing/opening a CSV file?
I could also create an Excel document using office automation.

Which method is prefered?

Now here is another piece of information. I am doing this in the Compact Framework.

Any information is welcome.

Thanks,
Einar