Can you open the file in Excel?
I don't use (or own) Excel, but am able to open it without problems in both Numbers and Open Office.
:::argh:::: Accidentally clicked a link that flagged @PhilModJunk's response as "Best Answer" and can't find a way to undo it. Sorry.
I would download a different xlsx file and test. Or reload a previous file that DID work.
A bit can be flipped in transfer that most programs ignore and others balk at.
It's consistent, in that every single .xlsx file is being refused.
Just looked back at my original post, and see I accidentally misspoke. In the past, Google provided .xls downloads, which always worked. Google now provides only .xlsx, which FM refuses to import.
The FM website clearly advertises both formats as accepted, thus my frustration.
Sorry 'bout the typo in my original post.
P.S. Anyone know how to un-Best Answer a response? I didn't mean to click that link on the first response to this query (no offense, PhilModJunk), since it isn't an answer or solution.
No offense taken and there's no easy way to "unselect" an answer--you are far from the first to accidently click that, I've done that myself. It takes either Modman or one of the "TS" folks to fix that one.
If you have FMP installed on more than one machine, I'd test this on another machine. That should tell us whether the problem is unique to one machine or not. In the same spirit, you can create a small test database and try importing into it. If that works, the issue lies with your file and maybe it should be recovered.
Sorry it took so long for me to respond. Wanted to wait until I had my MBP back from the Apple Store (repair) to try this out on the machine I use most often.
Sure 'nuff. It won't import there either, to the same database. Got the same error message as before (when trying to import on the Air).
This is odd, since it's a database that's been in active use for several years, and on FMP 12 since shortly after the version release.
FMP 12.0.2 on both
In the same spirit, you can create a small test database and try importing into it. If that works, the issue lies with your file and maybe it should be recovered.
I have seen other postings with users having problems importing Excel file formats created by Numbers. I would suggest using a different file format to see if the import works, possibly CSV or Tab-delimited.
@PhilModJunk: Tried it. Still a no-go. Between trying mutliple computers, different operating systems (all OS though), downloading from different browsers, and importing to different FM databases, there's only one common thread left. Google Docs.
The files DO open in Numbers and OpenOffice. Only FM refuses to accept them.
Why this worked flawlessly, but suddenly, stopped, is beyond me.
@TKTexas: We're not importing from Numbers---these are .xlsx files downloaded from Google Docs, originated on Google Docs Forms. Have been using this process for nearly four years, with this specific FM database. Rather than complicate our ongoing processes, or add yet more steps to "wash" the .xlsx files to make them work, I'd prefer FM update whatever is tripping up when an .xlsx import is involved.
The issue may lie with some change made in how Google Docs generates the file. If you feel that this is a possible bug, you can click on Report an Issue and report it. You can save typing by posting a link to this thread instead of re-stating everything already posted here.
@PhilModJunk: Sounds like a plan. I just tried four more downloaded files (from Google Docs) in two more FM databases on two different computers. Still stuck. FM won't even touch the .xlsx files.
Thanks for the suggestion--washing every single download through OpenOffice to convert it to .xls (which does still work) is quickly becoming a problem.
davidanders suggetsed: "I would download a different xlsx file and test."
Can I emphasize his suggestion: "I would create a different xlsx file in Excel or some other application and test."
As far as I can see you are always testing a GoogleDoc 'xlsx' file format, and then saying that FM12 won't import xlsx files. If you have an Excel-generated xlsx file will it import? Or what happens if you export data from an FM file in xlsx format? Does FM import it then?
The suggestions are to isolate whether the change is on the part of FM12 and its reading of xlsx files, or on GoogleDocs and its generation of them.
I hear what you're saying, but 100% of the spreadsheets we work with are downloaded from Google Docs--not one is generated locally (we don't even own a copy of Excel).
Additionally, exporting from FM isn't the issue/problem--that works, but import (the issue here) doesn't.
Bottom line, FM advertises that it's capable of importing .xlsx documents. There's no "but only if it's generated directly from Excel, Numbers, etc." qualification.