>I am converting data from an Excel spreadsheet to a VFP table.
>
>I am using an automation approach, opening the worksheet and extracting data from each cell. But sometimes I run into a problem where the value in a cell is not of a "character" type. For example, I have a column with heading "My Date". The values in this column are:
>1/20/2005
>10/1/2004
>and so on.
>When I get this value in the VFP program it is not a character type, because function CTOD() fails. How do I determine what type it is?
>
>Thank you.
Hi Dimitry,
Just use VFP TYPE() function
? type( 'oXLSheet.Cells[1,1].Value' )
Regards
Herman