> ok,
> if i create many tables with same fields(columns),and delimter type?
>
> how i can
> append many of text files to those tables, via same code
>
> thanks again
>
> >
> > How the data in text files is stored, I mean delimter type?
> >
> > You should have same number of fields as columns in the text file and the fields/column order too. You can try the following command:
> >
> >

USE T1
> > APPEND FROM t1.txt TYPE DELIMITED

> >
> > Regards,
> > akram

CLOSE TABLES
DIMENSION la_tables(5)
la_tables[1] = "t1"
la_tables[2] = "t2"
la_tables[3] = "t3"
la_tables[4] = "t35"
la_tables[5] = "t58"

FOR ln_CntrTbl = 1 TO ALEN(la_tables)
  lc_table = la_tables[ln_CntrTbl]
  USE (lc_table) EXCLUSIVE
  ZAP
  lc_txtfile = la_tables[ln_CntrTbl] + ".txt"
  APPEND FROM (lc_txtfile) TYPE DELIMITED
  USE IN (lc_table)  
ENDFOR

Regards,
akram