General information
Category:
COM/DCOM and OLE Automation
Chris,
I assume you're using something like: lo_Excel.Cells( 1, 1 ).VALUE. If so, try: lo_Excel.Cells( 1, 1 ).TEXT.
HTH,
Jonathan
>I am trying to read an Excel field formatted as a Time into Visual FoxPro 6.0 SP4. When I read the value I get the numerical equivalent of the time.
>If I try to change the format on the Excel field to Text in Excel, it converts it to a number.
>
>Does anyone know a way I can read this field into foxpro as a character string?
>
>Thanks.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only