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

> >
>
> You can use AFields() to determine column names.
>
> If you'd be using VFP9, and given that the XLS has three columns only, and if you want to import into an existing table, you could probably use the * placeholder:
>

> Insert Into mytable (col1,col2,col3) Select * From ...
> 

>
> If the table does not exist yet, you can:
>

> Select * From ... Into Table newtable
> 

>
>
>
> hth
> -Stefan

stefan i use vfp7, this code

Insert Into mytable (col1,col2,col3) Select * From ...

occurs an error with syntax error, and i use afields() already, but the column name that showed from afield cannot be called using sql syntax, i dont know why..

thank you for respond me stefan