AnsweredAssumed Answered

Import limit?

Question asked by sts1956 on Mar 23, 2012
Latest reply on Mar 28, 2012 by TSGal

Summary

Import limit?

Product

FileMaker Pro

Version

10

Operating system version

Mac OS 10.6.8

Description of the issue

When I ask Filemaker to open a .xls file, I will only get 255 records, where the excel file has substantially more data than that. Is there a limit?

Steps to reproduce the problem

Open Filemaker 10
Browse files
Click on button to show excel files
select .xls file
Open.
See (very briefly) progress bar
File opens with 255 records. .xls file has 6650 lines

Expected result

6650 records

Actual result

255 records

Exact text of any error message(s) that appear

no message

Workaround

save .xls file as tab delimited.
Open in BBEdit and verify contents.
Save as tab delimited.
Open in Filemaker
all records present.

Outcomes