Can't reproduce this in Windows XP. I create an Excel spread sheet with three columns of data and "Field 1", "Field 2", "Field 3" in the top row as column headers/field names.
I entered portions of nursery rhymes into the 1st, 2nd, 3rd columns of row two long enough that the text was more than would fit in the columns.
When I imported the data into Filemaker 11v3, they displayed correctly in the import dialog and imported correctly into the database.
This could be yet another Lion specific issue or it might be an issue with your excel file. You might try replicating my test on your system to see if you get the same problem or if it imports successfully.
Not sure why except possibly that this was exported from MySQL so perhaps something else is going on?
Well, that's why I suggested running this test on your system--to see if further investigation of the Excel file might reveal an issue...
It's an extremly simple spreadsheet. A few text columns, a few number columns and the timestamp column.
After I did experiment for a while, the only thing that made a difference was what I reported: resizing the columns.
The date format exported from MySQL was definitely not recognized by FMP. Once I changed the date format, then I could do the grouping report.
I appreciate all your terrific replies and suggestions. :)
It may be a very simple spreadsheet, but it's one created by an application other than Excel. My thought is to use Excel to create a similar spreadsheet with a row or two of manually entered data and then testing that file. That test can rule out the possibility that either the data or the file created by export from MYSQL is the source of the trouble...