↓ Skip to Main Content
Profile
My Course
Certificates & Extensions
Certificates
Course Extensions
Student Card
Course Transcripts
Study & Career Guide
Learning Tools
The Study Process
Career Advice
Finding Job Opportunities
Optimizing your LinkedIn Profile
Online Applications
Writing the perfect CV
Successful Cover Letter writing
Successful Telephone Interviews
On-site Interviews
More Courses
Support
Student Helpdesk
Review Your Course
Home
›
Unit
›
Get external data from a Microsoft Access database
Get external data from a Microsoft Access database
Posted on
April 12, 2018
by
Admin-login-gfox99
Posted in
Sorry, but you're not allowed to access this unit.
‹
About external data and data connections
Data in a Microsoft Access database will already be stored in tables. When you fetch the data, you will need to identify the table to import. If the database is a relational database, you may need to fetch the data from a query that combines data from different tables. To get data from a Microsoft Access database: Select the cell where you want to insert the data On the Ribbon, click the Data tab In the Get External Data group, click the From Access button The Select Data Source dialog box will be displayed – this is similar to a standard Open dialog box. Locate and select the database file, and then click Open The Select Table dialog box will be displayed. In the list, choose the required Table or View Click OK The Import Data dialog box will be displayed. If you just want the table data in the worksheet, choose Table – otherwise choose PivotTable Report or PivotChart and PivotTable Report as required Using the Where do you want to put the data options, make sure that the correct cell is chosen, or alternatively choose New worksheet Click OK The data will be imported into the Excel worksheet. It will be formatted automatically as an Excel table. A connection to the data source will probably be established, but security settings on your computer could prevent this.
›
Top
CONTACT A COURSE TUTOR