![]() When you have finished selecting the tables, click on the OK button. In this example, we have selected the Suppliers table. Highlight the tables that you wish to link to. ![]() Then select the radio button called "Link to the data source by created a creating table" and click on the OK button. In this example, we are selecting the Testing2.accdb file. Next, click on the Browse button and find the Access file that contains the tables that you wish to link to. ![]() Then click on the Access button in the Import group. To link to a table from another Access database, select the External Data tab in the toolbar at the top of the screen. Linking to a table from another Access database Question: In Microsoft Access 2007, how can I link to a table in another database?Īnswer: You are able to link to tables from other databases, whether the table is an Access table, an Oracle table, an Excel spreadsheet, or even a text file. See solution in other versions of Access:
0 Comments
Leave a Reply. |