The problem with the conversion of DBF => XLS

[Eugene Lutsenko]

I'm sure the problem is a problem of size of field, because I had the same problem and solved it when I adjusted the size so that it meets the standard DBF Dbase III.

I'll try to do it again with dimensions much smaller than the maximum

[skiman]

Hi,

This solution will not work with a recent version of Excel. It doesn't support dbf files anymore.

[Wolfgang Ciriack]

Hi Chris,
wenn i rename a text.dbf in test.xls, Excel 2013 open this without any error.
So what do you mean by your statement ?

[skiman]

Hi Wolfgang,

Yes, you are correct. I was convinced that DBF wasn't supported anymore. You can't open a DBF or save to a dbf. However, it looks as the functionality is still somewhere in Excel.

So, if it is only for opening and viewing a dbf, it will work.

[Eugene Lutsenko]

Excel-2007-2011 DBF-file opens but does not allow write XLS-file as DBF. But how does this relate to convert DBF => XLS using the Native is not very clear. Maybe Alaska function uses DBF => XLS converter Excel and if not, then gives an error?

[Auge_Ohr]

hi,

look at c:\exp19\Source\Dclipx\_dcfunct.prg for DC_WorkArea2Excel().
it does use activeX to access Excel COM Interface.

if you want to create a Excel Sheet native have a look on libxl.dll http://www.LibXL.com
in German Xbase++ Forum Hubert have made a Wrapper Class using ot4xb and libxl.dll
http://www.familie-brandel.de/index_e.html

[unixkd]

try Xlsgen

http://xlsgen.arstdesign.com/

Joe