After the simple Excel form is converted to VFP, the problem of long strings is intercepted

xiaoxiao2021-03-06  117

I am not familiar with the database. If you want to handle some simple table, you can use Excel to be good enough, and it is very useful to use the form of forms of forms or the data accumulated by data. But I often encountered this problem: If there is a longer text data, after the DBF database is exported, it will be intercepted, resulting in data corruption (if the ID number is truncated as several digits).

I didn't pay attention to it before, and I accidentally found this, because Excel then retracted the field width, if the form is exported to the DBF table, the default DBF field width is not pressed according to a cell data length, and It is based on the field width displayed by Excel, so that the generated DBF database is truncated. The simple method of solving is of course the adjustment field width in Excel, although it doesn't make the strength, but at least the cell that makes the data is completely exposed, and the reproduction data will not have problems.

转载请注明原文地址:https://www.9cbs.com/read-101972.html

New Post(0)