Duane,
I plan to do some more testing of the databases and will report in if I
find any other gotchas.
As reported in the thread on beta@, I did find that MM/DD/YYYY format does import as a date when the column Type is set to Date. But only exactly that format, with leading zeros required. That may be useful, as Excel will let you convert general dates formats to that.
/g/beta/message/5790-- Shal