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