Affiliates

Amazon.com


Popular Microsoft Access Books

Building Microsoft Access Applications
Building Microsoft Access Applications
Author: John L. Viescas 

Access 2003 All-in-One Desk Reference for Dummies
Access 2003 All-in-One Desk Reference for Dummies
Author: Alan Simpson 

Access 2003 for Dummies
Access 2003 for Dummies
Author: John Kaufeld 

Office 2007 All-in-One Desk Reference For Dummies
Office 2007 All-in-One Desk Reference For Dummies
Author: Peter Weverka 

Microsoft Office Access 2003 Step by Step
Microsoft Office Access 2003 Step by Step
Author: Online Training Solutions Inc. 

Access 2007 Bible
Access 2007 Bible
Author: Michael R. Groh 

Microsoft Office Access
Microsoft Office Access
Author: Steve Lambert 

Beginning Access 2003 VBA
Beginning Access 2003 VBA
Author: Denise M. Gosnell 

Microsoft Office Access 2003
Microsoft Office Access 2003
Author: Gary B. Shelly, Thomas J. Cashman.... 

Popular MS Access Related Websites

Microsoft Corporation 













Microsoft Access 2007 Tutorials for beginners    

Welcome to MS Tips and Tricks
Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Access tutorials for beginners, covering the following categories - Databases, Customization, Table, Forms, Queries, Reports, etc.,

  Microsoft Access Tips and Tricks for beginners
Get external data. Import and Export {Tutorial for beginners}  
 
Written by Ravi Prakash  
Friday, 29 June 2007
Category MS Access 2007 - Data.  
 
General Information
 
 
Importing from another database
Import Data: appending in an existing table
Export Data
 
 
Importing from another database
 
There are many ways to take data of a data base from Access to another one. The simplest method is to copy them and paste them, but importing and linking it, will allow you to have better control and provide greater flexibility respect to the data. 
 
During the import operation, it is possible to chose the objects that are desired to copy, to control how the tables and the queries are moved, to specify the relations between tables, etc. 
 
1) Look for the data base of origin and identify the objects that wish to import.
 
2) If the source data base is a mdb or accdb file, you can import tables, queries, forms, reports, macros and modules.
 
3) If the source data base is a mdb or accdb file, only tables can be imported.
 
4) Close the source database. Be sure no user has it open in exclusive way.
 
5) Open the target data base. Be sure that the data base is not read only.
 
6) Open TutorialDB. Select the Get External data tab and select the Access option.
 
Illustration 1: Select the right import command. In this case, Access command.  Click here to view larger image.
 
7) Browse for the source database.
 
Illustration 2: Select the source database.  Click here to view larger image.
 
8) If you want to import the data, select the Import tables option.
 
9) If you want to link the source table selects the Link data source option. This option does not import the data. It permits to view and work with the data that remains stored at the source database.
 

 
Advertisement



Advertisement



Copyright MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster