Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing time values from Excel
Message
From
21/07/2003 11:25:57
 
 
To
16/07/2003 16:04:05
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00810809
Message ID:
00812020
Views:
24
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform