fmpdude

FileMaker Cannot Open XLS Files Created By VFP Query

Discussion created by fmpdude on Sep 19, 2017
Latest reply on Sep 19, 2017 by fmpdude

Product and version (e.g. FileMaker Pro 14.0.3): 14.0.6

OS and version: Mac OS 12.10.6.

Hardware: MBP, 32 GB RAM

 

Description

I have a Visual FoxPro 9 application that creates, as part of a query, an XLS file. Yet, when I try to import that XLS file into FMP, nothing happens. Nothing is imported. No errors. Nothing.

 

To "work around" (non-acceptable solution) this issue, I have to manually open each XLS file in Excel and then save them. Then, FMP can finally read them.

 

Although I've been willing up to this point to "work around" this frustrating FMP issue by manually working around the fact FMP can't open these simple excel output files, each with only a few rows, it's now becoming more of an issue. In particular, since Mac OS 10.13 won't support Mac Office 2011, I won't (probably) have a working Excel where I can manually fix these problems.

 

I don't know if you're aware of this problem or if it's been fixed in some version > 14.

 

I can send you an example file later this week for your testing if that would be helpful. Just send me an email address.

 

Look forward to hearing back from you.

 

Thanks,

 

Outcomes