missing data when importing from Excel file
I am trying to convert an Access database by first exporting to a table in Excel and then importing the Excel file into Filemaker Pro 10 Adv. There are about 60,000 records. I have tried xls and xlsx file formats and each time the field names are ignored as the 'Source' and only the first character of each field is imported, i.e. Sam Smith will import an S into the FirstName field and an S in the LastName Field.
Am I missing something? Are there limitations to the size of a table in FM?
I have run the latest updates to FM 10.0.3
Thanks in advance.
If you create a simple Excel document with field names on the first row
and a sample number of rows (records) and open in Filemaker, does it work as expected?
If you take the 60,000 file and delete 50,000 rows and open in Filemaker, does it work as expected?
You do not note your operating system version.