Forum Discussion
TomMackowiak
Nov 10, 2023Copper Contributor
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.
- JKPieterseSilver ContributorIf 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.