Get Excel version before VFP importing

Copper Contributor

i,

 

When you're "saving as" an Excel file you can chose a 5.0/95 or 97 - 2003 version.

But when the files are saved, both appear like a 97-2003 version in the properties.

I'm working on VFP9 and it crashes when you're importing a 97 - 2003 Excel but not when you're importing a 5.0/95.

That's why i need to know wich version as been selected to save the file before importing it in my database.

 

Ask me if you need more information about the problem, thank you in advance for helping me.

1 Reply
If you're able to open it as a binary, it looks like an Excel 5/95 file contains the test "Biff8" somewhere in the file and a 97-2003 doesn't.