General information
Category:
COM/DCOM and OLE Automation
Hi Scott
Thanks for your answer, You're right about the many different situations to face when importing, By now I've been already doing a daily process which has never been stable because of the several different situation I face each and every day because of very little changes.
Regards
Oscar
>Hola Oscar:
>I'm probably not much help. My experience with importing data from Excel has left me with the opinion that it leaves something to be desired. Since there isn't a time field per se in VFP you might have to convert the field to a string in Excel and send it over to VFP that way.
>
>I used Excel as an input medium for data gathered from various sources and frequently encountered difficulties. For example, if the user somehow changed the format of a character field to numeric the data would import incorrectly even though to the eye it looked fine. I used to get a lot of stuff in scientific notation because of this.
>
>Scott
>
>>Hi all
>>
>>I’m importing a datasheet from Excel, and one of the columns contains time data (hh:mm:ss).
>>
>>However, I’m getting a repeated value for all the records of this field: 12/30/99
>>
>>If I try to save the sheet in DBF format from Excel, the column contains empty data values.
>>
>>I’ll appreciate any hints in order to import this data correctly.
>>
>>Thanks in advance for any hints.
>>
>>Oscar Corte
Previous
Next
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