>thisform.text11.Value=GETFILE('xls') > >IMPORT FROM (thisform.text11.value) TYPE xls > >use JUSTSTEM(thisform.text11.value) >tt=JUSTSTEM(thisform.text11.value) >USE (tt) excl > > >ALTER TABLE (TT) ADD COLUMN TXPNO C(19) >ALTER TABLE (TT) ADD COLUMN YEARe C(6) >ALTER TABLE (TT) ADD COLUMN INFTYPE C(2) >ALTER TABLE (TT) ADD COLUMN INFDATE C(12) >ALTER TABLE (TT) ADD COLUMN OFFCODE C(6) >ALTER TABLE (TT) ADD COLUMN ENTRYID C(15) >ALTER TABLE (TT) ADD COLUMN ENTDATE C(12) >ALTER TABLE (TT) ADD COLUMN CONFFLAG C(3) >ALTER TABLE (TT) ADD COLUMN CONFID C(12) >ALTER TABLE (TT) ADD COLUMN CONFDATE C(12) > >replace TXPNO WITH THISFORM.TEXT1.Value >replace YEARe WITH THISFORM.TEXT2.Value >replace INFTYPE WITH THISFORM.TEXT3.Value >replace INFDATE WITH THISFORM.TEXT4.Value >replace OFFCODE WITH THISFORM.TEXT5.Value >replace ENTRYID WITH THISFORM.TEXT6.Value >replace ENTDATE WITH THISFORM.TEXT7.Value >replace CONFFLAG WITH THISFORM.TEXT8.Value >replace CONFID WITH THISFORM.TEXT9.Value >replace CONFDATE WITH THISFORM.TEXT10.Value > >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)&& syntax error >next >>