Beautiful!

Thanx Edward and John!

>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???