Bruce,

I can import the stuff if I break it up into 5 spreadsheets of 20 rows, but importing the 100 in one go gives the error 13872 (which is above the usual 4 -digit error numbers reported by VFP).
Importing the entire spreadsheet gives the C00005 error.

I pasted values only into a new spreadsheet, so I hope that wiped out any special formatting that may have existed in the original spreadsheet.

Any other ideas?

Cyril.



>>I am trying to export an Excel spreadsheet into VFP6 (SP3) with:
>> Append from (impfile) type XL8.
>>
>>1. If I append 20 rows at a time, no problem.
>>2. If I append 100 rows, I get "Unknown error code: 13872".
>>3. If I append the entire spreadsheet, I get the C00005 error.
>>
>>I can save it to Excel 4 and it imports fine. But the users are demanding support for their new Excel format. Any suggestions? (and what is error 13872?)
>
>Are you certain there's no special Excel formatting on some of the cells? That's caused trouble for me...