>>>>>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/954318Tamar
