Forum Discussion

TomMackowiak's avatar
TomMackowiak
Copper Contributor
Nov 10, 2023

Get Excel version before VFP importing

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.

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    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.

Resources