>>>I need to insert records from one table to another, the tables have the same name, so the database, but they are in diferent directories.
>>>
>>>I open the first table and wend i try to open the second it always find the first table .
>>>
>>>What can I do to resolve this situation ?
>>>
>>>
>>>Thanks
>>>Carla
>>
>>I would recommend opening ALL tables with ALIAS then referring to the alias.
>>
>>USE table1 IN 0 ALIAS FileOne
>>USE table2 IN 0 ALIAS FileTwo
>>
>>You can then open as many tables as you like with the same name. Personally, I even include alias when it is the same as the table name - to force the habit.
>

Correction on the previous 2 replies.

Enforce the directory to work efficiently.

USE first_dir\table1 IN 0 ALIAS alias1
USE second_dir\table1 IN 0 ALIAS alias2

SELECT alias1
blah...blah...blah...
SELECT alias2
blah...blah...blah...