際際滷

際際滷Share a Scribd company logo

Import Data From Databae Into Excel

dinesh takyar
dinesh takyar

This document provides steps to import data from an Access database into Excel: 1) Click Data and select Import External Data, then New Database Query; 2) Select MS Access Database and the database file (e.g. Northwind.mdb); 3) Choose the data to import such as fields from the Customers table; 4) Apply filters if desired, such as importing only records where the contact name starts with "m"; 5) Select the starting Excel cell and import the filtered, sorted data.

1 of 15
Import Data into Excel from a database like Accesshttp://www.familycomputerclub.com
http://www.familycomputerclub.comA presentation by familycomputerclub.com
http://www.familycomputerclub.comClick on DataSelect Import External dataClick on New Database Query
http://www.familycomputerclub.com4. Click on MS-Access Database and then OK
http://www.familycomputerclub.com5. Find the database file like northwind.mdb as shown in the next 際際滷s
http://www.familycomputerclub.com6. The final path to the File Northwind.mdb is shown here
http://www.familycomputerclub.com7. Now we look for the data to import
http://www.familycomputerclub.com8. We have selected Contact Title, Contact Name and Phone from the customers table
http://www.familycomputerclub.com9. Before importing the data we can also apply filters to import specific data
http://www.familycomputerclub.com10. Here we wish to import all data with contact name beginning with m
http://www.familycomputerclub.com11. Data is also sorted
http://www.familycomputerclub.com12. You can save the query at this point to run it automatically later
http://www.familycomputerclub.com13. Select starting cell where the data will be imported into Excel
http://www.familycomputerclub.com14. All the data with contact name beginning with m and sorted in ascending order has been imported!
http://www.familycomputerclub.comThanks for watching!

More Related Content

Import Data From Databae Into Excel