>>>>Hi Dimitry,
>>>>For working with Excel and VFP, you should take a look at the different procedures by Vilhelm-Ion Praisach
http://praisachion.blogspot.com/. Vilhelm has produced very fine classes to import and export from Excel to VFP and from VFP to Excel both for xls and for xlsx type files.
>>>>A must to try before you decide.
>>>>Regards,
>>>>Koen
>>>
>>>Hi Koen,
>>>
>>>I saw a message about this procedure, yesterday, and actually tried it several times. It takes forever even his test, very small .xlsx file. I never got it to the end, had to terminate the task. It is no good.
>>
>>Dimitry,
>>out of curiosity, which procedure did you test?
>>Regards,
>>Koen
>
>=appendfromxlsx()
>
>And I actually tried a few of the variations in the test.prg that comes with that library.
Dimitry,
which version did you use?
and did you use one of your 'own' .xlsx files or an available sample from the Internet?
I keep on asking as I donot have this experience at all, it is remarkable fast 4000 record in less than 2secs.
Koen