Product and version FileMaker Pro Advanced 22.214.171.124
OS and version windows 10
My 3rd party software produces an excel file that I use to import. Sometimes this file only contains the header record, and no data records. That part is out of my control. When the file only contains the header record and no data records, Filemaker crashes during the import. I am trying to import via a script into a SQL Server table. If there are one or more data records, the import works fine. The SQL table is a simple table with no triggers, and I removed the auto increment to no avail.
How to replicate: Import into SQL Server table no data records, just header record.
Workaround (if any) None found.