>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???
You can run GenDBC to get script for all DBC-stuff includeing CREATE TABLE ... etc. You may cut the script which is related to the table you want to move and run it within target DBC to get empty table with the same structure. After this you just APPEND data from one table to another.
Edward Pikman
Independent Consultant