One other simple alternative is to do a "Save As DBF" file... even if automation... You'll at least get a dbf file you can work natively against, then cleanup the garbage directly from VFP.


>Hi,
>Try deleting the 10 rows immediately below the data, if the rows/cells are protected Clear All doesn't work.
>
>>No, they are visible. I did a Clear on them (hightlight the cells, Edit/Clear/All) and tried the import again and got the same thing.
>>
>>The code is:
>>
>>

>>CREATE CURSOR ImportCursor;
>>	(item c(15), price n(10,2))
>>APPEND FROM <ExcelFileName> type xl8
>>

>>
>>>Hi,
>>>Are the rows hidden in the spreadsheet.?
>>>
>>>>I have a situation where I'm importing data from a simple two column spreadsheet. There are 894 rows. All 894 rows import just fine, but at the end of the file I get some junk.
>>>>
>>>>This is what I get. As you can see, the last record (and all the ones before that) is imported fine, but I get three additional records. Lines 895, 896, and 897 in the spreadsheet are completely empty - no data, no formula.
>>>>
>>>>

>>>>Record#  ITEM               PRICE
>>>>    894  7580KTPA           55.05
>>>>    895  0
>>>>    896  7.7468171E-304
>>>>    897                     3.33E-308
>>>>

>>>>
>>>>Unfortunately, I get a numeric overflow error. But where the heck does it find this nonexistent data?
>>>>
>>>>Russell Campbell