>hi all,
> if i have text files as t1,t2,t5,t35,t58 ,
>
>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
>
>
>
>
>*mstr empty table have fields as column1 to column32
>CLOSE all
>COPY FILE mstr.dbf TO t1.dbf
>COPY FILE mstr.dbf TO t2.dbf
>COPY FILE mstr.dbf TO t5.dbf
>COPY FILE mstr.dbf TO t35.dbf
>COPY FILE mstr.dbf TO t58.dbf
>
>
>thanks
>
>
Try
APPEND FROM TextFile1 Field1 type delimited
APPEND FROM TextFile2 Field2 type delimited
etc.
If it's not broken, fix it until it is.
My Blog