Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import excel to foxpro
Message
From
15/06/2005 21:31:51
 
 
To
15/06/2005 03:37:13
James Beerbower
James Beerbower Enterprises
Hochheim Am Main, Germany
General information
Forum:
Visual FoxPro
Category:
ActiveVFP
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01023322
Message ID:
01023772
Views:
10
Dear James,

Thank you for your feedback. I'm using the import wizard and the example is just an example. ok i give u the right example:
Record in last row in first column in xls = REF-030891
Record in last row in first column in dbf =7.746817146097E-304

Thank you.

>A couple questions:
>a) are you using
>
>append from ... xls
>or the import wizard
>or using OLE automation e.g.
>m.lnValue = loWb.sheet(1).cells(x,y)
>
>to import the data?
>
>b) Is "0002345 will become 7.77678999E" literally true? Exactly what value is converted to what value?
>
>By the way sometimes type conversion is responsible for such oddities -- for example, a date type is converted to a numeric. You can try making your foxpro fields character to get around the problem.
>
>Jamie Beerbower
>
>>Dear all,
>>
>>I need help from you all. When i import data from excel into dbf format, the last record on the first column will became other number(Eg. 0002345 will become 7.77678999E.)How can i overcome this problem?
>>
>>Thank you
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform