SQLTeam.com | Weblogs | Forums

Cannot open dbf file created in Visual Foxpro 7 or 9 in EXCEL 2010


#1

Before upgrading to EXCEL 2010, I am able to open dbf files created in Visual Foxpro 7 or 9 in Excel 2003.

I am not sure why after installing EXCEL 2010 I am no longer able to open the file.

I get the error message when I tried opening the dbf file in Excel 2010 "the file you are trying to open is in a different format than specified by the file extension"

I have tried opening the dbf file via the File Open method but it still cannot work.

If I copy the file to a lower dbf format (type fox2x) then I am able to open the file in Excel 2010

Does Excel 2010 support dbf files created by Visual Foxpro 7 or 9?


#2

Seems like you already posted this question on SQLServerCentral and got an answer. Did the answer you accepted, not solve your problem?