>>>Hi
>>>I create an excel file from my file ( copy to ... type xl5 ). After some work on the worksheet, i want to update my table back. It keeps erroring in the date field when bringing it back. Is there an easy way to achieve this without creating a date string, importing there then moving it from VFP?
>>>
>>>Thanks
>>>Jaime
>>
>>Hi Jaime,
>>
>>It depends on what is going on with "some work on the worksheet", and you "update my table back". I do not think that you will see errors with the plain calls like:
>>
>>copy to (ExcelFile)... xl5
>>append from (ExcelFile) xl5
>>
>>What are errors related to yours "keeps erroring in the date field"? And what are you doing with the information in Excel file?
>
>Well the application scans the worksheet ( i.e for each row ) and does a REPLACE command on the table. When replacing VFPDateField with ExcelDateField i get an error. I tried running stuff like .Range('D:D').NumberFormat='dd-mm-yyyy' but still no go.
>
>Jaime
what is output for:
? VARTYPE(ExcelDateField)