I am having quite an issue here, I have a dbf file which I opened and edited in excel (to shortcut editing by adding formulas) saved it and imported it to a table in MS Access 2010 (since excel 2010 doesn't have an option to save in dbf format for dbase), when I export it back to dbf (dbaseIII) it gives me an error "Field will not fit in record". I have read that it has something to do with the length of the field so I edited all field length from 255 down to 100. Still I am having the same error. What can I do with this?

I also tried using a lower version of excel and I was able to export the file back to dbf and opened it in dbase. In dbase, I discovered that the fields were changed for example, those fields with text like "JOHN DENVER SMITH" were only displayed as "JOHN DE " or something like that, exporting back to dbf, changed some properties on the dbf file. How would I be able to convert it properly?


Thanks in advance.