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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham