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...
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement