SQLTeam.com | Weblogs | Forums

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

#1

Hello everyone
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?
Thanks

0 Likes

#2

import data from foxpro to sql server then open using excel

0 Likes

#3

Nice! Thanks for the tip!

0 Likes