logging in or signing up how to import data fro a database like ms-access into ms-excel takyar Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 156 Category: Entertainment License: All Rights Reserved Like it (0) Dislike it (0) Added: September 17, 2010 This Presentation is Public Favorites: 0 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 Posting comment... Premium member 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! You do not have the permission to view this presentation. In order to view it, please contact the author of the presentation.
how to import data fro a database like ms-access into ms-excel takyar Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 156 Category: Entertainment License: All Rights Reserved Like it (0) Dislike it (0) Added: September 17, 2010 This Presentation is Public Favorites: 0 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 Posting comment... Premium member 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!