Thank you for your post.
The easiest way to export from Excel is Text (tab-delimited). This creates a text file with tabs separating field values and returns separating records. The date format is retained. For example, if you have three cells with dates:
The text file contents will look exactly the same. It will not export a 5 digit number.
Thank you TSGal, I will give this a shot and report back. I'm off on vacation so it may be a week or so.
If you can control the excel file use, you can set the date format via a formula.
This transforms the date field into a text string that you can import. If you know the string is always MM/DD/YYYY or any format, you can import as text and then use a formula on another field to turn this into an FMP date.
You can't blame this one on Microsoft. I've imported from Excel to several different databases and never had trouble importing dates (or any other data) until I started working with FMP!