How to Stop Excel from Cutting Off Cell Values When Saving as DBF
When saving an Excel file as DBF 4, I was finding that the values in one column were getting truncated.
Well it turns out that you have to change the width of your columns to avoid this behavior. So make sure every column width is wide enough to show the full text from that column before saving as DBF. (Even make it wider than auto width to be safe.)
Do note that when saving in DBF 4 format from excel, it will still insist on cutting off your header (first row) values at 10 characters.