Ricardo Aráoz wrote: > Problem is I don't find any property that allows to open (or import) a > file in a specific worksheet. So if I am to use several worksheets I'm > stuck with either inserting cell by cell, or opening a file (csv) in a > second (auxiliary) workbook and then cut and paste (which can be > vulnerable through the clipboard). > Ricardo
I think you are trying to rely too much on Excel and not enough on VFP. First of all I assume you are trying to get a large number of rows of data from VFP into Excel. 1. Different versions of Excel have different (row) limits, IIRC ca 16K/64K depending on version 2. Again IIRC EXPORT/COPY TO ...TYPE ... respects the (appropriate/corresponding) Excel limits - no that's not right - check the (VFP) help - I know that VFP has similar limits (16K/64K rows) for this/these commands. So Use (Dave C's suggestion) of DATATOCLIP but do it 16K/64K rows at a time. From VFP, create/open an Excel workbook - add as many worksheets as you need (in advance or as needed) For each DATATOCLIP, set the active cell in Excel to the corresponding cell (A1) and worksheet and paste the data. Does that help ? Paul Newton _______________________________________________ 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.
