dear fox pro experts, i'm trying to insert data from cursor that i got from odbc.
lcXLS file = getfile()
lnConn=SQLSTRINGCONNECT("Driver={Microsoft Excel Driver (*.xls,*.xlsx,*.xlsm,*.xlsb)};DBQ=&lcXlsFile")
SQLCOLUMNS(lnconn,"[sheet1$]",'NATIVE','crscolumns')
SQLTABLES(lnconn,"","sheetnames")
scan
lctablename=trim(sheetnames.table_name
lcoutput=chrtran(m.lctablename,'$','_')
SQLEXEC(lnConn,'select * from ['+m.lctablename+']',m.lcoutput)
endscan
how could i retrieve column name from m.lcoutput into column in a dbf table
select * from &lcoutput into cursor tr
select tr
go top
do while !eof
insert into mytable (col1,col2,col3) values * how to get the column of cursor tr
enddo
thanks in advance