Exporting with Field Names

[jrollins]

When exporting data from a Filemaker database to either a CSV or SLK file is there some way to export the field names into the first row of the exported data?

Thanks.

[Fenton]

Try the Merge format. It has the field names in the 1st row. The format of that row is slightly different, it has no quote marks, but otherwise it's the same as a .csv file.

[xochi]

You can also use DBF format. If you rename the file from *.dbf to *.xls, it will (generally) open into Excel with a double click.

DBF has some limitations:

1. fieldnames are made all capitals and truncated at 10 characters

2. very large exports (many fields) seem to take a long time, and I've occasionally run into some sort of maximum length that causes the export to fail.

[jrollins]

That works! Thanks.