FM9 has a 65000 record limit for XLS exports (on Mac OS X).

Has this restriction been lifted in FM 11 ?

If not, what's a good alternative export format for very large #s of records. Tab-delimited text is fast, but you lose field names.

Edited July 14, 201015 yr by Guest

Ahh -- I just remembered the "merge" format which is really CSV with fieldNames in the first row. That may be a solution for now as I'm still in FM9.

OP:

I think the 65K limit is in Excel not in Filemaker.

PS if you script the tsv export and make the first line export the fieldnames then append everything after that you will preserve the arrangement of your data

OP:

I think the 65K limit is in Excel not in Filemaker.

The limit is clearly enforced in Filemaker 9.

The latest versions of Excel don't have this limitation:

see http://blogs.msdn.com/b/excel/archive/2005/09/26/474258.aspx

Whether FileMaker could start using this new file format with no row limitation? Not sure...

Update: i switched over to the "merge" export format. This is basically CSV with field names in the first row.

Works nicely, AND is much much faster than the XLS export format for some reason...