FiveTech Software tech support forums

Buenas tardes. Necesito recuperar datos de una planilla de excel y guardarla en una dbf. estoy usando fwh 12.6 y harbour 3.1 rev 17222. busque en el foro y vi una funcion que implemente pero al compilar da el error: unresoved external _HB_FUN_FW_EXCELTODBF es por las version que manejo? alguien me p...

... simpler: 1. Open the excel book with Excel application and leave it open. Then, // open or create dbfFW_ExcelToDBF()  The function ExcelToDbf() will read the used range from the open workbook and write to default alias. However what I am not sure, till I test at my end, is whether ...

FWH has built-in functions GetExcelRange() and FW_ExcelToDBF() for this purpose. But your data is huge, better to use a custom approach for this case. 1) Save Excel sheet as CSV and then copy to DBF. OR 2) Reading row by row is ok. Instead, read in chunks, ranges of 20,000 approx in a loop and save ...

Dear Mr. Rao,
Is there a standalone example.
If yes, are these functions working with mod harbour.
I think a mod harbour sample which uses EXCEL as a "small database" would be great.
Best regards,
Otto

Silvio.Falconi wrote:Now I resolve with

IF oImport:ExcelToDBF( oRange, nil, .t. )
lreturn :=.t.
ENDIF

But I not Know if it is correct!!

Correct.

Now I resolve with

IF oImport:ExcelToDBF( oRange, nil, .t. )
lreturn :=.t.
ENDIF

But I not Know if it is correct!!

I think that you need to have a alias active for that file.

select DBINFO // target for the exeltodbf
FW_ExcelToDBF( oRange, nil, .t. )

oImport:=TImport():New() IF FW_ExcelToDBF( oRange, nil, .t. ) lreturn :=.t. ENDIF give me error wich is the right command ? Error Error occurred at: 19-01-2022, 13:39:00   Error description: Error DBCMD/2001  Workarea non in use: DBINFOStack Calls===========   Called from: &...

Hi.
WhatsNew Fwh2106 contains this:
* Función FW_ExcelToDBF(): Elimina los ceros a la derecha después del decimal al
convertir números a texto.

Maybe it can help you.
Regards

Mayo 2021, Junio 2021 ===================== * XBROWSE: = Mejora a oSortCbx: En la versión 2104, el combobox mostraba los nombres de los índices, que pueden ser diferentes de los nombres de las cabeceras. En esta versión el combobox muestra por defecto los nombres de las cabeceras. El programador pue...

May 2021, June 2021 =================== * XBROWSE: = Enhancement to oSortCbx: In release 2104, the combobox was displaying index names, which may be different from the header names. In this release combobox displays header names by default. The programmer can display index names instead of header na...

May 2021, June 2021 =================== * XBROWSE: = Enhancement to oSortCbx: In release 2104, the combobox was displaying index names, which may be different from the header names. In this release combobox displays header names by default. The programmer can display index names instead of header na...

I am thinking of making this change in the FWH next version.

I sent modified dbffunc2.prg to your email. Please check and let us know. Yes !! I tested some files and they work as aspected.. Thank you very much. The newly added function gives me also the option to format more specific data when converting... Great. For compatability (I have full and clean FW/...

I sent modified dbffunc2.prg to your email.
Please check and let us know.