Hi Mohammed,

tt isn't the name of your cursor. Its just a variable. To access the Field in 'tt' you could use macro substitution.

&tt..name


>hi all,
>
>i need to use table after convert it from excel sheet as below,
>

>CLOSE all
>SET DATE BRITISH
>SET CENTURY on
>thisform.text11.Value=GETFILE('xls')
>IMPORT FROM (thisform.text11.value) TYPE xls
>use JUSTSTEM(thisform.text11.value)
>tt=JUSTSTEM(thisform.text11.value)
>CLOSE all
>USE (tt) excl
>FOR gnCount = 1 TO FCOUNT( )
>   m.OldName =  FIELD(gnCount)
>   m.NewName = ALLTRIM(EVALUATE(FIELD(gnCount)))
>      ALTER TABLE (tt) RENAME COLUMN (m.OldName) TO (m.NewName)
> NEXT
>
>tt=JUSTSTEM(thisform.text11.value)
>CLOSE all
>USE (tt) excl
>
>**i try tt.name,ot (tt.name) not works
>
>**********************************************
>
>
>lnFields=AFIELDS(laFields)
>SELECT 0
>CREATE TABLE qcombined1 (name c(LEN(tablename.name)),amt c(17),dedcode c(4)***error (tablename.name)
>

>
>thanks