AnsweredAssumed Answered

FileMaker crashes when importing no records from excel to SQL table

Question asked by fmnotsopro on Jul 24, 2017
Latest reply on Jul 24, 2017 by fmnotsopro

Product and version FileMaker Pro Advanced 15.0.2.220

OS and version windows 10

Description

 

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.

Outcomes