I have been reading alot of information about the problems with using the Append command to convert an Excel 2007,2010 file to something VFP can import. The other issue that there seem to be a problem with is trapping for the error that crashes the program if the user trys to import a file that is not saved in the correct format. It seems to corrupt the file it is being appended to. In most cases I can't force the user to do a save as or remember to do a save as in excel.
The easiest way would be to have a command line function that would convert any Excel file into a compatible format that VFP9 can append from. Maybe an XL8 or some other format.
The problem that I have is, that the spreadsheet I need to import, comes via email from many different people who have different versions of Excel. All of the spreadsheets have the same design or layout but different information. The users don't want to deal with doing a save as. Or they just forget too. Setting a different default save format is not an option they will agree with.
A command line converter that detect version infomation would do the trick. Even a window application that can detect which version of Excel is being used and default to a single compatable excel format to convert to.
Thanks for any help
The easiest way would be to have a command line function that would convert any Excel file into a compatible format that VFP9 can append from. Maybe an XL8 or some other format.
The problem that I have is, that the spreadsheet I need to import, comes via email from many different people who have different versions of Excel. All of the spreadsheets have the same design or layout but different information. The users don't want to deal with doing a save as. Or they just forget too. Setting a different default save format is not an option they will agree with.
A command line converter that detect version infomation would do the trick. Even a window application that can detect which version of Excel is being used and default to a single compatable excel format to convert to.
Thanks for any help