Hi Ian:
USE database1!mytable
COPY TO C:\otherdirectory\mytable WITH CDX DATABASE database2
Do this will all tables and then go and copy the files back to the original directory.....go back into the new combined database and dbl-click on each table....you'll be forced to Locate each table...fine, locate 'em.
Problem resolved.
>I have 3 distinct VP6 Databases that I wish to merge into one database, without losing any information.
>
>If I try to add a table from one DB into another DB, VFP informs me only Free Tables can be added to a DB. If I remove a table from a DB to make it a Free Table, I lose my long file names, which obviously not very desireable - these are big tables.
>
>I can not find any documentation on this issue.
>
>Is there any way around this catch 22???
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05