Importing from Access


show more Importing from Access provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Importing from Access

Sometimes you need to analyze large amounts of data from other sources in Excel. The easy part is doing the analysis, the hard part is getting the information into Excel. Luckily, 2007 has made that part much easier. Using import commands, you can populate worksheets with lots of data from other sources. We're going to take a look at some ways that you can do that in this chapter. Open up a new worksheet to follow along. Click on the Data tab to find the commands that allow you to get external data. In this movie, we're going to see how we can import from an Access database.

Simply click on the From Access command, and find your access database. Now this may take a little bit of looking, but what we're going to look for is the Exercise Files, that came with the application, and we're going to look for the Importing_Exporting_Data file folder. Once you've opened that, you'll see the EatCake database. Highlight it, and click open. You then get a dialog box asking you which ...

Importing from Access
Video duration: 2m 24s 5h 13m Beginner

Viewers:

Importing from Access provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...