ganesh5566
01-29-2014, 09:02 AM
Hi,
Im using one addin in excel 2010 which converts the file to dbf 5. While converting if a cell value length exceeds 128, the entire value gets truncated. Im using the below code .
<Code>
Dim tbl As ADOX.table
Dim col As ADOX.Column
Set col = New ADOX.Column
lenlong=Len(r.Cells(2).Text)
col.Type = adLongVarWChar
col.Precision = 254
col.DefinedSize = lenlong
tbl.Columns.Append col
</Code>
Please help me on getting this solved... Thanks in adv..
Regards,
Ganesh V
Im using one addin in excel 2010 which converts the file to dbf 5. While converting if a cell value length exceeds 128, the entire value gets truncated. Im using the below code .
<Code>
Dim tbl As ADOX.table
Dim col As ADOX.Column
Set col = New ADOX.Column
lenlong=Len(r.Cells(2).Text)
col.Type = adLongVarWChar
col.Precision = 254
col.DefinedSize = lenlong
tbl.Columns.Append col
</Code>
Please help me on getting this solved... Thanks in adv..
Regards,
Ganesh V