Microsoft Office Tutorials and References
In Depth Information
Import Data from an Access Table
Chapter 7: Importing Data into Excel
The Import Data dialog
box appears.
9 Select the Table option.
!
9
If you want to import the
data directly into a
PivotTable, you can select
the PivotTable Report
option, instead.
0 Select the Existing
Worksheet option.
! Click the cell where you
want the imported data
to appear.
0
@
If you want the data to
appear in a new sheet,
you can select the New
Worksheet option,
instead.
@ Click OK.
Excel imports the data to
the worksheet.
More Options!
If the Access database requires a login password, you may need to type the password
again when you refresh the imported data. To avoid this extra step, tell Excel to save the
database password along with the external data. If you have the Import Data dialog box
onscreen, click the Properties button; if you have already imported the data, click the
Data tab, click the Refresh All drop-down arrow, and then click Connection Properties. In
the Connection Properties dialog box, click the Definition tab, click to select the Save
Password check box, and then click OK.
 
Search JabSto ::




Custom Search