FW_ExcelToDBF : number and text issue
Posted: Tue Nov 10, 2020 9: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 ?
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 ?