>>>>Using VFP8. I need to append data from 10 differents tables having different structures into 1 Excel sheet. anyway to do this other than inserting a cell at the time?
>>>
>>>I'm also using _vfp.DataToClip(,,3) - though I'm usually removing the header line from _cliptext, as my field names would just confuse the end user - I usually have template sheets and paste into predefined areas, which already have neatly formatted header rows. Something like this:
>>>
>>>

set memowidth to 1023
>>>cFirstLine=mline(_cliptext,1)
>>>_cliptext=strtran(_cliptext, cFirstLine+chr(13),"")
>>>oRange.PasteSpecial()

>>>
>>>Now the "multiple tables" part begs knowing some details: do they need to be on the same page (in which case you may have to consolidate them into a single cursor first), or can they be one page at a time. In the latter case, Naomi's way is the simplest.
>>
>>I think he wants them in the same sheet. And I don't think the data could be combined into one cursor.
>
>In that case, paste one, go a few (Excel) rows below that, paste next table, calculate the next blank row, go a few rows below that, paste next...

Dragan, Naomi

I was able to add the tables into one sheet using VFPOLEDB by doing what Dragan suggested. isert one table then skip few lines and insert another table. using VFPOLEDB worked fine because I have the tables in one database.

I needed to have them on one sheet so we can use Oracle plsql and parse the file easily.

Thanks
Mo