http://wiki.lessthandot.com/index.php/Linking_Tables_via_Jet_and_ADOMartinaJ
>>Hi Tariq
>>
>>You can create new MDB a add tables from other MDBs as LINKED table
>>
>>MartinaJ
>>
>>>Dear Experts
>>>
>>>Folder1 has followng mdb's
>>>
>>>asia.mdb
>>>Europe.mdb
>>>
>>>
>>>and Folder2 has these mdb's
>>>
>>>
>>>africa.mdb
>>>australia.mdb
>>>
>>>
>
>
>>>I want to combine all above mdb's into single mdb.
>>>
>>>Tables in all mdb's have same structure. i.e. field names and filed length etc.
>>>(Folder Images are also attached)
>>>
>>>Please help
>
>
>Sir, thanks but I am looking for VFP codes to link tables.