I'm trying to import from an excel file. Everything works fine except the date. The worksheet has the date stored in a custom field that looks like this:

mm"/"dd"/"yyyy

On the worksheet it looks like a normal date (01/01/2001).

When it gets imported into a VFP date field, the value is " / / ", when I use a character field, I get some 5 digit number that doesn't seem to resemble the date to me.

Can anyone shed some light on this for me. I need to know how to import this into a VFP table without manual manipulation.

Thanks.