FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour FW_ExcelToDBF : number and text issue
Posts: 1487
Joined: Tue Jun 14, 2016 07:51 AM
FW_ExcelToDBF : number and text issue
Posted: Tue Nov 10, 2020 09:37 AM

While trying to read exel data and storing to dbf i often have following.

The first column is a reference code and has a mix of numbers and text data. (I have no impact on these data)

The function often converts it to :

Code Result Hoping to get
1234 1234.00 1234
Txt1234 Txt1234 Txt1234

I changed the column in exel to text format, but still Fw converts as number.

How do I solve this ?

Marc Venken

Using: FWH 23.08 with Harbour

Continue the discussion