TechRepublic|Forums|Software

Software

Question

  • Creator
    Topic
  • December 10, 2008 at 1:15 pm #2166792

    Excel 2007 Sheet Length Problem

    Locked

    by megan · about 15 years, 4 months ago

    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!

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Answers

  • Author
    Replies
    • December 10, 2008 at 1:15 pm #2973488

      Clarifications

      by megan · about 15 years, 4 months ago

      In reply to Excel 2007 Sheet Length Problem

      Clarifications

    • December 10, 2008 at 4:08 pm #2973430

      Pre-parse input data

      by wrleeii · about 15 years, 4 months ago

      In reply to Excel 2007 Sheet Length Problem

      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.

  • Author
    Replies
Viewing 1 reply thread