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:
A Get External Data-Access Database dialog appears:
- Click Browse button to look for location of Database1 database
- Click Ok
You will get an Import Object dialog box below
- 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.
- Select any table you want to link
| |||||||||||||||
| ......................................................................................................................... | Home | Forum | About | Contact | ||
| 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. | |||
| Copyright @ 2011-2013 worldbestlearningcenter. All Rights Reserved. | |||
