excel tutorialMicrosoft Query
This chapter teaches you how to import data for an unlisted format by using the Microsoft Query Wizard. With Microsoft Query, you can select the columns of data that you want and import only that data into Excel.
To import data using Microsoft Query, execute the following steps.
1. Open an empty Excel file.
2. On the Data tab, in the Get External Data group, click From Microsoft Query.
The 'Choose Data Source" dialog box appears.
3. Select MS Access Database* from the Databases tab and make sure 'Use the Query Wizard to create/edit queries' is selected.
Note: select <New Data Source> and click OK to create a new data source.
4. Click OK.
5. Select the database (northwind.accdb) and click OK.
This Access database consists of multiple tables. You can select the table and columns you want to include in your query.
Query Wizard
1. Select Customers and click the > symbol.
2. Click Next.
To only import a specified set of records, filter the data.
3. Click City from the 'Column to filter' list and only include rows where City equals New York.
4. Click Next.
You can sort your data if you want (we don't do it here).
5. Click Next.
6. Click Finish to return the data to Microsoft Excel.
7. Select how you want to view this data in your workbook and click OK.
Result:
Did you like this free Excel tutorial? Show your appreciation, vote for us.