AnsweredAssumed Answered

FileMaker import XLSM data

Question asked by jasongan on Apr 11, 2014
Latest reply on Apr 11, 2014 by philmodjunk

Title

FileMaker import XLSM data

Post

     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.

     Please advise.

      

     thanks,

     Jason

      

      

Outcomes