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.