How to Embed a SQL Query in Microsoft Excel

PDF download Download Article
PDF download Download Article

This article will help users to embed SQL Query in Excel 2010 and create a dynamic connection in Excel.

Steps

PDF download Download Article
  1. Step 1 Go to Data tab and select From Other Sources as shown in the screen shot below.
  2. Step 2 Select “From Data Connection Wizard” in the drop down.
    Advertisement
  3. Step 3 Data Connection Wizard will open.
    Select “ODBC DSN” from the available option and click “Next”.
  4. Step 4 Connect to ODBC Data Source window appears.
    Where a list of database available in our organization will be displayed. Select the appropriate database and click on “Next”.
  5. Step 5 Select Database and Table window appears.
  6. Step 6 We can select the database and the table from where we wish to pull the data.
    So, select the database and table as appropriate in our case.
  7. Step 7 Select Finish in “Save Data Connection File and Finish” window.
    This window will pull up the File Name based on our selection in previous screens.
  8. Step 8 Import Data window appears where we can select options as per our need and click OK.
  9. Step 9 Select “From Data Connection Wizard” in the drop down.
  10. Step 10 Go to Data tab and Click on Connections.
    Click on Properties in the following window.
  11. Step 11 Go to Definitions tab in the following window.
  12. Step 12 Write SQL query in “Command Text” and Click OK.
    Excel will display the result as per the query.
  13. Step 13 Now go to Microsoft Excel and validate if the results are as per the SQL Query written.
    14. Advertisement


Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement

Tips

Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Submit
Thanks for submitting a tip for review!

You Might Also Like

Connect Excel to an Oracle Database
How to
Connect Excel to an Oracle Database
Activate Power Query in Excel 2016
How to
Activate Power Query in Excel 2016
Create a Database from an Excel Spreadsheet
How to
Create a Database from an Excel Spreadsheet
Automate Reports in Excel
How to
Automate Reports in Excel
Import Web Data Into Excel on PC or Mac2 Ways to Import Data from the Web into Excel: Windows & Mac
Open an SQL FileView and Edit SQL Files: MySQL Workbench, Excel, & More
Link Sheets in Excel
How to
Link Sheets in Excel
Link an Excel File to a Word Document
How to
Insert Excel Into Word: Step-by-Step Guide
Create a Form in a Spreadsheet
How to
Create a Form in Excel: Step-by-Step Guide
Create a Currency Converter With Microsoft Excel2 Simple & Quick Ways to Create a Currency Converter in Microsoft Excel
Use Microsoft AccessThe Ultimate Guide to Using Microsoft Access
Link Tables in Access
How to
Link Tables in Access
Use the Lookup Function in Excel
How to
Use the Lookup Function in Excel
Create Pivot Tables in Excel
How to
Create Pivot Tables in Microsoft Excel to Analyze Data
Advertisement

About This Article

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time. This article has been viewed 388,294 times.
How helpful is this?
Co-authors: 5
Updated: January 8, 2016
Views: 388,294
Categories: Microsoft Excel
In other languages
Thanks to all authors for creating a page that has been read 388,294 times.

Is this article up to date?

Advertisement