Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing time values from Excel
Message
De
21/07/2003 11:25:57
 
 
À
16/07/2003 16:04:05
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00810809
Message ID:
00812020
Vues:
25
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
Scott Ramey
BDS Software
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform