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
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