Thanks for replying,
At the outset I don't want to create new relationship / field.
Since The relationships are already defined in Database1, I just want to import the Tables along with the relationships from Database1 to Database2.
As mentioned before, i am able to import the table to Database2 but not its relationship.
Further, when I tried to execute the following code, it gave me the error as stated below.
Set f = rel.CreateField("DeptID", dbInteger) [error : Type mismatch]
f.ForeignName = "DeptID" [method or data member not found]
I am using the following Reference in my project :
a) Microsoft ActiveXData Object 2.5 Library
b) Micorsof DAO 3.6 Object Library
c) Microsoft Access 9.0 Object Library