Are the exported files by any chance in Excel .xls format? Lion does not support that format. You will need to change them to .xlsx if they are.
OK…any ideas on whether I have to do this extra step or not?
barenose, I'd address you by name, but you didn't sign your post. Keep in mind that Excel will open .htm file. Can you export as HTML and get Excel to open the file?
Also, you can export as XML, and using XSLT, create the open office format that Excel will open (.xls)
JB here. I haven't tried exporting as html, only xml and xslt. I tried my script on the server today and it worked fine without the external export/import. Want to know if I really have to create that extra step.
All the best,
Also, you can export as XML, and using XSLT, create the open office format that Excel will open (.xls)"
Beverly, I assume that you mean to select the XML type and switch the suffix to ".xslt", true?
If so are there other reasons / uses to utilize this ?
don't be confused between XLS (Excel) and XSL (XML stylesheet).
exporting to .xml ( by means of applying the .xsl with the export ), yes the resulting extension can be changed to .xls (Excel). but it can also be .xml. the "format" of the result XML is open office that Excel uses. for an example, export (from Excel) as XML!
the .xsl (.xslt) are not opened by Excel, but used to transform FileMaker XML into the Excel XML.
-- sent from my iPhone4 --