Kidstuff? It took me awhile to come up with something :)
1) COPY TO tblNew DATABASE C CDX.
2) COPY TO tblNew, the field names will be truncated.
3) COPY STRU TO tblNew CDX, ADD TABLE tblNew.
HTH!
Mark
>I know this is kids stuff but I just started using DBCs.
>
>I have table A in database B.
>How do I:
>1. Copy table A to database C and retain things like long field names etc.
>2. Copy table A to a free table which does not support long names.
>3. Copy table A, structure and indexes, to table D in the same database B.
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.