>>>>>>>>>Hi,
>>>>>>>>>
>>>>>>>>>I am trying the command IMPORT at a spreadsheet saved as Excel 2003. The command I use is
>>>>>>>>>
>>>>>>>>>import from MyFileName type xl8
>>>>>>>>>
>>>>>>>>>Every time I try (in VFP 9 Command Prompt) the VFP crashes. What should I look for as a cause of this problem? TIA.
>>>>>>>>
>>>>>>>>Workbooks saved as Excel 2003 from later versions of Excel aren't actually in the Excel 2003 format.
>>>>>>>>
>>>>>>>>Tamar
>>>>>>>
>>>>>>>I will check for the exact version. Thank you.
>>>>>>
>>>>>>I suggest to not attempt to use Import command anymore. Check Craig Boyd's program or try APPEND FROM. I recommend the first and I recently implemented it in my utility.
>>>>>
>>>>>I don't know which Craig Boyd's program you mean so maybe when you come back to UT on Sunday you can let me know. And I didn't know that APPEND FROM can be used for Excel spreadsheet; or maybe I am mistaken.
>>>>
>>>>APPEND FROM does work for Excel workbooks that are in the 2003 and earlier format. The problem is that when you Save As that format from Excel 2007 or later, or from Excel 2003 with the add-on that can read XLSX files, the file you get isn't really in the Excel 2003 format, and VFP chokes on it (though I haven't actually seen crashes).
>>>>
>>>>See this KB:
http://support.microsoft.com/kb/954318>>>>
>>>
>>>It's a shame Excel and FoxPro do not come from the same vendor, then all this could have been avoided ;-)
>>
>><g>
>>
>>You can be sure that if we were writing the Hacker's Guide now, this one would have a bug icon (though I consider it an Excel but, not a VFP bug).
>>
>
>I definitely blame it on the Excel team (even though you have a son who is on it). FoxPro compatibility wasn't something they were going to be bothered with.
>
>PS for readers -- Tamar's son did not join the Office team until much later and I don't know that he has worked with Excel specifically.
He's on the SharePoint team.
As for this bug, my take is that if you say you're saving in a particular format, you have to save in that format, not in some minor variation of that format. Nothing to do with VFP, and I'll bet it's not the only app that has trouble with this.
Tamar
