Microsoft Office Tutorials and References
In Depth Information
Importing Data from Microsoft Access
The Select Data Source dialog box opens (see Figure 18-4). If the database from which you
want to import data is local, browse to the file’s location and select it. If your target Access
database resides on a network drive at another location, you will need to have the proper
authorization and access in order to select it.
3. Navigate to your sample database and click Open.
Figure 18-4: Choose your source database.
In some environments, a series of Data Link Properties dialog boxes open, asking for
credentials (that is, username and password). Most Access databases don’t require logon
credentials, but if your database does require a username and password, type them in the
Data Link Properties dialog box.
4. Click OK.
The Select Table dialog box (see Figure 18-5) opens. This dialog box lists all the available
tables and queries in the selected database.
Figure 18-5: Select the Access object you want to import.