Get external data from Access
database into Excel 2007
Getting external data from databases like MS-Access
into Excel 2007 takes a few clicks. You can now extract information
from the imported data using 'auto filter' or 'advanced filter'. You
can also use the in-built functions or custom functions to perform
calculations with the relevant fields. Performing such calculations or
extraction of information in the database program may be more tedious
or require special programming skills like building SQL (structured
Query language) queries.