Are you importing from a file of data exported from the original file or are you importing directly from the original file?
If importing from an exported file of data, check the data file by opening it in Excel or a text editor to see if the data was exported successfully.
If this is what you've done, try importing the data directly from the original file instead of from an intermediary file. FileMaker 9 and FileMaker 11 have exactly the same file formats so you should have no trouble importing directly from the original FileMaker file.
If all else fails, try importing from the original file, but use the new table option instead of the table you have created. Then examine this new table to see if the data was fully imported. If not, you may want to recover the original file and then import from it.
I fixed my problem. I recovered the file and that didn't do anything.
I attempted to import from the original file rather than an intermediary file and that didn't work.
I checked the other tables in the file and a related table was missing data that must have been required. I re imported the data in the related table and then imported the problem file and everything is good.
thanks for the suggestions.