What if an input file has more than 16,384 records

From Support

If you have a question or seek clarification, please call Technical Support.

Problem:

Looks like we've bummed into 16,384 records per file limit to be DISPLAYED when converting to MS Excel. DataImport documentation says "there is no limit to the number of lines that can be translated using a mask" How do I get "Records per File Split" to work?

Solution:

The Excel format is limited to 16,384 lines per file. You could use the "DataImport Utilities" program to split the file by length to create a series of input files that contain fewer lines per file. The process type to use in the Utilities program is called "Records per file split". This allows the user to determine where to split the number of lines in each file. Then each input file has to be run through the appropriate DataImport mask.

If your files are larger than 16384 lines, you should probably be using a database ouptut format such as .DBF (Dbase) or .MDB (MS Access).

NOTE: This is not true regarding the latest version of Excel. (Add version # and row limit)