>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.