Excel 2003 how to export to DBF with a field of fraction?
 

Dear Sir,

In Excel 2003 I have many fields such as debet, kredit
debet is 999,999,999.99 (fraction of 2 decimal points)

The question is how can I make sure the exported fields are including the
decimal value?? (When I export to DBF the value of decimals are lost)

thanks in so much!

Excel 2003 how to export to DBF with a field of fraction?
 

Hi Johan,

If your fields are General fields then the values that you see in the cell
will export. (99.99 will export as 100), but if you set your fields as
Numeric with 2 decimal places then you will get the number as shown in the
value bar at the top (99.99 will export as 99.99). Also, be sure do
double-click the columns to auto-size them to the widest value, otherwise
Excel may set the field width to the first value it sees, and not export
larger values correctly.

--
Cindy Winegarden



VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx




"Johan2000" wrote in message
...
Dear Sir,

In Excel 2003 I have many fields such as debet, kredit
debet is 999,999,999.99 (fraction of 2 decimal points)

The question is how can I make sure the exported fields are including the
decimal value?? (When I export to DBF the value of decimals are lost)

thanks in so much!

Excel 2003 how to export to DBF with a field of fraction?
 

Hi Cindy Winegarden,

Thanks for helping me out...
Your name Cindy Winegarden just Hit Me....
Long time ago you help me out.....
This time you help me out again....

Thanks so much, may God Bless You.....
may all the good spirit stay with you.....

Excel 2003 how to export to DBF with a field of fraction?
 

Hi Johan,

Thanks for your kind words. I'm glad you've solved your problem.

--
Cindy Winegarden



VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx




"Johan2000" wrote in message
...
Hi Cindy Winegarden,

Thanks for helping me out...
Your name Cindy Winegarden just Hit Me....
Long time ago you help me out.....
This time you help me out again....

Thanks so much, may God Bless You.....
may all the good spirit stay with you.....