>Hi All,
> I would like to know, how to copy data on the fly from a FoxPro (VFP6) table to an excel TEMPLATE . All the columns headings are set in the template according to the fox table.
>
>Any help would be greatly appreciated.
>
>TIA
>
>- Jeana -
use (tcMyTable)
afields(aStruc)
create cursor Dummy from array aStruc
copy to tcXLSFile type xls
oExcel = createobject('Excel.Application')
oExcel.Workbooks.Add(tcXLSFile)
oExcel.Visible = .t.
Cetin