Access Database Load Upload Into Seperate Tables

Import database objects into the electric current Admission database

Access for Microsoft 365 Admission 2021 Access 2019 Access 2016 Admission 2013 Access 2010 Access 2007 More...Less

Access provides a number of means to copy an object such equally a table or form from i database to another. Copying and pasting an object is easiest, but importing an object from a different Access database into your current database offers you more options.

Overview

You can import tables, queries, forms, reports, macros, or modules from one Access database into your current database. When you import an object, Access creates a re-create of the object in the current database.

Are yous wanting to import data and tables into your Access database? Encounter Import or link to data in another Admission database for specific information and considerations about importing data and tables.

You import database objects when you demand to practise either of the following tasks:

• Copy the pattern and layout of a form, a report or other object from a different Access database into your current database as a quick way to create a new grade, report or other object.

• Copy the latest version of a course, written report, or other object from a unlike Access database into your current database at regular intervals. To do this, you can create an import specification the first time you lot import the object, then utilise the specification to repeat the operation later.

Note that importing an object from a different Admission database into the current database differs very little from opening a 2nd database and then exporting the object from the starting time. The two chief differences between importing and exporting objects betwixt Access databases are:

• You can import multiple objects in a single operation, simply y'all cannot export multiple objects in a unmarried performance. If you want to export multiple objects to some other database, it is easier to open the destination database and and so perform an import operation from inside that database.

• In addition to database objects, you tin can import relationships betwixt tables, plus any import and export specifications, and carte du jour bars and toolbars. You tin can also import a query every bit a table. Exporting does not offer you these options.

Import a database object from another Access database into your current database

1. Open the database that you lot want to import objects into, if information technology is not already open up. The file format tin exist either MDB or ACCDB. If the file is in MDE or ACCDE format, you'll only exist able to import tables and queries from other Admission databases. You can't import forms, reports, macros, and modules into an MDE or ACCDE file.

2. The location of the import wizard differs slightly depending upon your version of Access. Cull the steps that lucifer your Access version:

   • If yous're using the latest version of the Microsoft 365 subscription version of Access, on the External Information tab, in the Import & Link group, click New Data Source > From Database > Access.

   • If you lot're using Access 2016, Access 2013, or Admission 2010, on the External Data tab, in the Import & Link group, click Access.

3. Access opens the Get External Data - Access Database dialog box.

4. In the File name text box on the Become External Information - Access Database dialog box, type the name of the source database or click Scan to display the File Open up dialog box. Scan to the source database, select it, then click Open.

5. Select Import tables, queries, forms, reports, macros, and modules into the electric current database and click OK to open the Import Objects dialog box.

6. In the Import Objects dialog box, click each tab and select the objects you want. To cancel a selected object, click the object again. To select all objects for import on the electric current tab, click Select All. Click Deselect All to cancel selecting all objects on the electric current tab.

   

7. Click Options to specify additional settings. The following table describes how each option impacts the results of the functioning.

   Chemical element	Description
   Relationships check box	Select to import the relationships betwixt the selected tables.
   Menus and Toolbars check box	Select to import any custom menus and toolbars that exist in the source database. The menus and toolbars are displayed on a tab named Add-Ins.
   Import/Export Specs check box	Select to import whatsoever saved import or export specifications that exist in the source database.
   Nav Pane Groups bank check box	Select to import whatsoever custom Navigation pane groups that be in the source database.
   All Images and Themes check box	Select to import any saved images or themes that exist in the source database.
   Definition and Data selection button	Select to import the structure and data of all selected tables.
   Definition Only option button	Select to import only the fields in the selected tables. The source records are not imported.
   Equally Queries selection button	Select to import the selected queries equally queries. In this case, retrieve to import all the underlying tables forth with the queries.
   As Tables option button	Select to import queries as tables. In this example, you demand not import the underlying tables.

8. Click OK to outset the import functioning.

   Access copies the objects and displays mistake messages if information technology encounters any problems. If the functioning succeeds in importing the objects, the last page of the wizard allows y'all to save the details of the performance as an import specification for hereafter utilize.

   The import functioning does not overwrite or modify whatsoever of the existing objects. If an object with the same proper noun in the source database already exists in the electric current database, Access appends a number (one, two, three, and and so on) to the proper name of the import object. For instance, if you import the Issues form into your database that already has a form named Issues, the imported form volition be named Issues1. If the name Issues1 is already in employ, the new grade will be named Issues2, then on.

What else should I know?

• For information on how to relieve the details of your import into a specification that you tin reuse later on, run into the article Save the details of an import or consign operation as a specification.

• For information on how to run saved import specifications, meet the article Run a saved import or export functioning.

• For information on how to schedule specifications to run at specific times, see the article Schedule an import or export functioning.

• For information on how to modify a specification name, delete specifications, or update the names of source files in specifications, see the article Manage Data Tasks.

Need more help?

smithwitteat.blogspot.com

Source: https://support.microsoft.com/en-us/office/import-database-objects-into-the-current-access-database-23aea08b-7487-499d-bdce-0c76bedacfdd

Share this post