I was thinking that if I can read the data directly from the workbook and not use the import/export options in excel/vfp maybe I can do something. Any advice?

>There's nothing you can do. How would you or program know what date '3/6/2000' represents. Is it March 6th or June 3rd of 2000?
>
>>I'm importing data from an excel worksheet and the date fields have mixed format, for example some records have a month-day-year format and others have the day-month-year format. How can I import these records into a foxpro database with only one date format? I'd really appreciate somebody can help me with this one.
>>
>>TIA,
>>
>>Enmanuel