>I'm trying to import an excel file into vfp 6.0 , my statement is
>append from myfi;e.xls type xls
>But there is a column in excel that has a time value p.e 17:36:09 , in the cells to modify excel values a see 5:36:09 PM , the when I'm importing into VFP the columns receive 09/09/1999 5:36:09 PM.
>Somebody knows whatr is the problem? . I'm trying to change the cells format but it didn't works.
>Thanks

I guess, Excel internally stores time as DateTime type. You can try to save to CSV file and then append fom it in foxpro

append from myfile.csv with delim