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