• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Getting Information Into and ... > Importing Information from an Access...

Importing Information from an Access Database

Suppose you already have an Access database that includes tables of information about products and orders, and another that includes contact information. Now you wish you had just one database so that all the information you use on a regular basis is in one place. You had to create the existing databases by hand and then type in all the data, and you don’t relish the thought of having to retype anything. You can take advantage of this earlier work by importing the product and orders information into the contacts database, rather than re-creating it all.


You can easily import one or more of the standard Access objects: tables, queries, forms, reports, pages, macros, and modules. When importing a table, you have the option of importing just the table definition (the structure that you see in Design view), or both the definition and the data. When importing a query, you can import it as a query or you can import the results of the query as a table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint