Is anyone running into a problem with the date field when appending from a csv file? The csv file contains a field value as 01/15/2007 and when using append from ... type csv command, the value on the cursor become 01/15/0007. This same command works fine in vfp6 and if I changed the type to delimited it also works.

Does someone know what's wrong here? or any suggestion will be appreciated.

Thanks.