Software

Ask something
Question Locked

Excel 2007 Sheet Length Problem

0 helpful
2 replies

by megan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi:

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!

2 replies

by wrleeii

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.

This discussion is closed to new replies.