Exporting >65,xxx records to Excel 2007 - Still issues

[DB_Noob]

NEVERMIND - FM 9 can't export to Excel 2007....Any Plug-ins or anything that can make FM 9 export to Excel 2007 (.xlsx):

Edited October 21, 2009 by Guest

[IdealData]

As FM only exports data to XLS, then it shouldn't matter that it is not in XLSX format as Excel 2007 can read both formats.

[DB_Noob]

Thanks. I do understand...however, I can't get FM to export more than 65,000 records to a single worksheet because FM can only export to .xls (which maxes out at around 65,000). If FM could export to .xlsx, then it can export > 65,xxx records...

Does that make sense? Or am I missing something?

[IdealData]

Makes total sense now - I missed your point about the 65k record limitation on xls exporting.

[Vaughan]

I just did a quick Google and Excel 2007 can have up to 1,048,576 rows.

Rather than Export as Excel, export as CSV or Tab delimited format. There is no row limitation on these file formats.