>A co-worker was beginning to develop an app to import data from an Excel file and then do whatever manipulations were needed. He created a dbf by saving the files as dbase III format and then zapped the file (so was blank). Went into VFP and used the table he had just created. Issued the command: APPEND FROM filename.xls TYPE XL5 (also try TYPE XLS). VFP seemed to think for a moment and then just disappeard/shut down without notice. I decided to try this on my computer to see what the results were...exactly the same thing happened.
>
>Has anyone had this happen to them? Is this a known bug that I missed?
>
>Thanks,
>George
George,
Is .xls file in Excel5.0 format ? That's the only version AFAIK that doesn't have bugs with 'append from'. Also VFP6 SP3 has corrected some of the bugs.
'import from' might be a solution. Another one is to save as CSV, delimited or dBaseIII format from Excel.
Cetin