J Jeff Boyce Mar 5, 2007 #2 Open new (empty) Access .mdb file. Use File | Get External... | Import... Navigate to and select the .mdb file with the tables you wish to import. Click the <Options> button and select/check Relationships. Complete the import. OR... Use File|Get External...|Link... (doesn't import the data, just links to it). Regards Jeff Boyce Microsoft Office/Access MVP
Open new (empty) Access .mdb file. Use File | Get External... | Import... Navigate to and select the .mdb file with the tables you wish to import. Click the <Options> button and select/check Relationships. Complete the import. OR... Use File|Get External...|Link... (doesn't import the data, just links to it). Regards Jeff Boyce Microsoft Office/Access MVP