Thank you for your post.
I was unable to reproduce your issue with FileMaker Pro 14 (Advanced) on Windows 7 Professional SP1 (64-bit). To attempt to reproduce I followed these steps:
1. Create test.fmp12
2. Input 40,000 records of sample fields and data
3. File > Export Records... > save "test.xlsx" onto my desktop
-it exported without issue
4. Deleted all Records
5. Closed and reopened the file
6. File > Import Records... > File... > "test.xlsx"
-imported all 40,000 records without issue
You might try reproducing this in a new file. If the issue doesn't occur in a new file you may run Recovery on your existing file. This can tell you if the file is damaged and even fix minor damage.
If you have any additional information needed to reproduce just let me know!
is there any validation in the schema that could be causing the import to fail?
This is a new file and like is said 13 has no problems what so ever importing and exporting all records. It is like I am missing some component\software on the computer to make 14 run correctly. I am trying a different computer now.
No there are no validations what so ever. this was just a quick test file that I created.
14 worked fine on my windows 8 machine.
Thank you for your responses.
We have still had no additional reports of this issue and I have been unable to reproduce. Can you update to FileMaker Pro 14.0.3 (Advanced) and see if the issue persists?
I look forward to your response.