>Currently, saving an Excel 2007 spreadsheet in Compatibility mode for Excel 8/2003 fails to import or append into VFP 9 as TYPE XL8. Hopefully someone in the Excel team will get that fixed. In the meantime, you can save the spreadsheet as Excel 5/95 and that will work. Of course, telling a client they have to save their work in a 12-year-old spreadsheet format limited to 16383 rows could make you look outdated... Or try saving as non-spreadsheet CSV type?
The guys from the Excel team will probably say that the hard coding in vfp is incorrect? Well, the least we could ask the members of both teams is that they discuss this together and offer us a 'best advice'. And hopefully a repair, either in vfp or in excel. Afterall, we are clients who have paid (several times) for these products.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.