Hi,
I will investigate that but you can
check the format used for dates in the Excel file (for example dd/mm/yy) and
see if it's the same in your application. By default FoxPro uses date in
American format (mm/dd/yy). The date format in your application
must match the one in your excel file.

In vFoxPro you can use the commands SET DATE and SET CENTURY to
make the date format match the one in your Excel files.

SET CENTURY OFF

SET DATE BRITISH
? DATE()	&& result 16/12/08

SET DATE AMERICAN
? DATE()	&& result 12/16/08

SET DATE USA
? DATE()	&& result 12-16-08

SET DATE JAPAN
? DATE()	&& result 08/12/16

SET DATE GERMAN
? DATE()	&& result 16.12.08

SET CENTURY ON
? DATE()	&& result 16.12.2008

SET DATE JAPAN
? DATE()	&& result 2008/12/16

Here are the settings and the resulting date formats:

Setting (Format)
AMERICAN (mm/dd/yy)
ANSI (yy.mm.dd)
BRITISH/FRENCH (dd/mm/yy)
GERMAN (dd.mm.yy)
ITALIAN (dd-mm-yy)
JAPAN (yy/mm/dd)
TAIWAN (yy/mm/dd)
USA (mm-dd-yy)
etc ...
>Hi,
>Thank for your reply.
>I find that the date format column in my excel worksheet cannot import to the cursor.
>all date value change to " / / " in the cursor after import. why ?
>
>Please advise.
>
>Thanks.
>Derek