Old DBF Files - After Foxpro adds a column Excel 2003 cannot open the File

[jcis]

My App works with old DBF files, maybe 2.0 and maybe they were not created with Foxpro, it's a standard here for certain telecommunicatio engeneering projects. The Foxpro Driver allow my app to make changes to these files, then i added a column after the last colum and Excel stopped opening the file with error "file type unrecognized..". Then I manually added the column from MS Foxpro 6.0 and the result was the same. Finally when i added the column in another position from foxpro (not as last column) Excel opened the dbf ok, the problem is I cannot do it from code using the foxpro driver, the only way i see would be creating a new dbf and this is not an option.

I think the real problem is Excel, it shouldn't be used to open this files but the user really needs Excel because it's the only tool that gives him enough flexibility when making many changes.

So, the question:

Is there any way, using foxpro ODBC Driver, to add a column in the middle (not as last column in the table)? Or..

Is there any way to keep compatibility between Excel and Foxpro after adding the column at the end?

I use RDO from VB6 to work with this dbf files, no problem untill now, everything work fine like insert, updates, deletes.. the problem begun with "ALTER TABLE", this could also be done using ADO but i think there would be no difference.

EDIT: Sample DBF attached