>>More polished than my 1liner for sure ;-) Quick nosy question - did you compare your approach of writing out to file and concatenating header line with that file to _clip to inserting header line and then inserting one row down directly fro .DataToClip(,,3)? On current SSD probably irrelevant, but it perked my "find best way" character deficit ;-)
>
>Did that regularly 10-12 years ago, and it was drastically faster. And it's not the amount of data (SSD being irrelevant for the case) but in the sheer amount of COM/DOM addressing when playing automation cell-by-cell or massaging a csv to do exactly what we want and not be misinterpreted. _vfp.datatoclip(,,3) combined with oExcel.Range.Paste() is the fastest I've found so far.
>
>>Quickscanned vfp2Excel, but have not done enough with .RS to form opinion.
>
>You should, it's a thriving domain - I frequent many .rs sites :)
Dragan,
_vfp.DataToClip() itself is slow and doesn't return correct data and needs to be controlled if data is not small. Transferring data via OLEDB is the fastest.
Details are in my previous reply to Thomas.