how to import data fro a database like ms-access into ms-excel

Views:
 
Category: Entertainment
     
 

Presentation Description

You can import data from a database like MS-Access into MS-Excel for further analysis using a query. While importing the data you can filter and sort it also. The steps are easy to perform!

Comments

Presentation Transcript

Slide 1: 

Import Data into Excel from a database like Access http://www.familycomputerclub.com

Slide 2: 

http://www.familycomputerclub.com A presentation by familycomputerclub.com

Slide 3: 

http://www.familycomputerclub.com Click on Data Select Import External data Click on New Database Query…

Slide 4: 

http://www.familycomputerclub.com 4. Click on MS-Access Database and then OK

Slide 5: 

http://www.familycomputerclub.com 5. Find the database file like ‘northwind.mdb’ as shown in the next Slides

Slide 6: 

http://www.familycomputerclub.com 6. The final path to the File Northwind.mdb is shown here

Slide 7: 

http://www.familycomputerclub.com 7. Now we look for the data to import

Slide 8: 

http://www.familycomputerclub.com 8. We have selected ‘Contact Title’, ‘Contact Name’ and ‘Phone’ from the customers table

Slide 9: 

http://www.familycomputerclub.com 9. Before importing the data we can also apply filters to import specific data

Slide 10: 

http://www.familycomputerclub.com 10. Here we wish to import all data with ‘contact name ‘ beginning with ‘m’

Slide 11: 

http://www.familycomputerclub.com 11. Data is also sorted

Slide 12: 

http://www.familycomputerclub.com 12. You can save the query at this point to run it automatically later

Slide 13: 

http://www.familycomputerclub.com 13. Select starting cell where the data will be imported into Excel

Slide 14: 

http://www.familycomputerclub.com 14. All the data with contact name beginning with ‘m’ and sorted in ‘ascending order’ has been imported!

Slide 15: 

http://www.familycomputerclub.com Thanks for watching!

authorStream Live Help