Information générale
Catégorie:
COM/DCOM et 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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement