Microsoft Office Tutorials and References
In Depth Information
IMPORT AN ACCESS DATABASE
into Excel
Many organizations use more than one application
to manage data. Excel is an excellent choice for
managing, analyzing, and presenting numbers.
Databases such as Access help you store, filter, and
retrieve data in large quantities and of every type.
By importing Access data into Excel, you can apply
easy-to-use data analysis techniques to complex
Access databases.
Instead of using worksheets, in Access you must
organize your information into data tables, each of
which stores information about one part of the entity
of interest to you: customers, products, employees,
transactions, and so on. To help keep track of these
tables in Access, you must create and assign unique
identifiers, called keys, to each table or have Access
automatically assign keys to each customer, product,
employee, transaction, and so on. Access uses the
keys to link tables to each other.
Excel simplifies the use of Access data tables. When
you import a data table, you can select tables or
columns of interest from multiple tables and display
the results in a single worksheet.
1
1
Open the workbook in which
you want to view Access data.
3
2
Click the Data tab.
2
3
Click From Access in the Get
External Data group.
The Select Data Source dialog
box appears.
4
Click here to select the folder in
which your Access database is
located.
4
5
5
Click your database.
6
Click Open.
6
206
Search JabSto ::




Custom Search