Microsoft Access 2007 tutorial:import and linked Table

Import And Linked Table

XI. Import Table

Importing Table is a process of getting a table or the tables into current access database from another access database. Example below will show how to import TblCustomer from SaleAndStock database to Database1. To do so, follow the steps:

- Open Database1 database

- Click External Data tab

- Click Import Access Database as a demonstrable figure:

Ms.Access Imported image

A Get External Data-Access Database dialog appears:

Ms.Access Get External Data

- Click Browse button to look for location of Database1 database

- Click Ok

You will get an Import Object dialog box below

Ms.Access Imported Dialog

- Click any table you want to import

- Click Ok

XII. Linked Table

Linking table is a process of connecting table from a database to another database and those tables have the same effects when you insert data, edit data and delete data. Linking table is similar to importing tables. But you have to select the second option as shown in the figure below.

Ms.Access Linked Table 

- Select any table you want to link



This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.