Excel 2007 Sheet Length Problem

By megan ·

I am trying to export a "FileMaker Pro" database into excel. I have over 100,000 leads in this file, and when I export to Excel, it only allows 65536 rows in length. Is there a way to expand the length of an individual sheet? I am missing well over half of my database when I export.

Please help!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Pre-parse input data

by wrleeii In reply to Excel 2007 Sheet Length P ...

Can you parse the 100K records into groups (say, alphabetically, and breaking them into groupings of a-f, g-k, ...)? Then you can import each group into a separate (tabbed-)sheet.

They don't all appear in the same sheet, but at least they are all in the same file.

Related Discussions

Related Forums