Richard Quilhot wrote: > There is a marco available called largefileimporter, that take a large text > file and breaks it up into 64K sheets. > Google "largefileimporter" > Thanks Richard, found it. Checked the VBA code and it does what I did in VFP, use automation to write each cell one at a time. Even if it might be a little faster than doing it from VFP I don't think it will be as fast as I need it to be (though I will test it when I have some time). I learned (from the VBA code) I should set Calculation, ScreenUpdating, DisplayAlerts and EnableEvents off though, that might speed up my VFP code a lot. I'll give it a go when I have some spare time. In the meantime I'll keep the recordSet method which is acceptable (barely). Thanks a lot.
_______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
