Import Access Data
- This is the database window of the Consulting database. In this Simulation, you are going to import the Invoices table from another database (rather than importing the data from a spreadsheet as you did in the last lesson).
- To begin, choose File>>Get External Data>>Import from the menu.
- The Import dialog box helps you find the file containing the data you want to import. The first step is to make sure you are looking at the write type of files. You want to import data from an Access database.
Access is already selected in the Files of type setting, so you do not need to make any changes. The file that contains the Invoices table is the Invoices.mdb file. Double-click the filename to choose the object to import.
- The Import Objects dialog box allows you to choose the object you want to import. Notice that for the tabs across the top, you can import any type of object. This can be very useful if you have already created an object similar to what you need in a new database.
In this case, however, you just need to import a table. Click the table called Invoices to select it, then click the OK button.
- The database window now shows the imported table called Invoices. The table has been imported in its entirety with data as well as all field properties.
Other Considerations When Converting data
Keep in mind that saving a file to a different file format is only a small part of the process. As already discussed, there may be issues involving code, references, macros, security, and integration with other applications.
For the most part, moving to newer versions is easier than moving backward. When converting to a prior version, some newer features may be lost or have only part of their functionality,
and custom features may not be recognized or implemented as expected. Despite those concerns, it is certainly handy to have the ability to save a file in an older format when you want to.
But what about times when only some of objects are needed?
Instead of converting an entire database, there is also the option to import database objects into an Access 2010 file, whether you need an MDB or ACCDB format. Importing objects does not automatically import or set the necessary references.
So if you import VBA objects that depend on specific references, you may need to manually add the same references to the new file.
To convert a database, it must be closed, meaning that no users can be accessing the database, and you essentially need to have the equivalent of Administrator permissions for the database.
Fortunately, the default mode for an unsecured database is for all users to have Admin permissions.
Linked Tables
When converting a database that contains linked tables, it is a good practice to ensure that the linked tables are still in the location specified in the Connect property.
Using the Linked Table Manager to relink to the current tables is a fast, easy way to refresh or update the links. After the database has been converted, the tables can be moved and the Linked Table Manager
can be used to relink to the tables in their new location.