FileMaker import XLSM data
Hi, FM Experts:
Is there a way that FileMaker importing can detect which file extension before import?
FM can't import data properly from XLSM file. Even the sheet I am importing only has 1 row, but because the file has macro and is saved as XLSM file, when FileMaker imports this XLSM file (forgot to save it as XLSX file), it imports forever and it has created 114000 garbage records already, and I couldn't stop the process.
So if I can detect the selected file extension, I can then stop the importing and give a warning message.