How To Compare SQL Data With Excel Data

(ScreenShots are available below)

You can compare SQL Server data with Excel data by selecting the SQL server data you are interested directly from Excel and then comparing in within Excel to other Excel data. It's easy.

1. Make sure you are connected to your SQL Server database.

2. Run your Select Query.

3. Rename the QueryResults Worksheet.

4. Change to -Excel Data Regions- as your source.

5. Refresh the regions.

6. You are now able to run SQL joining, comparing and querying the SQL Server data and other Excel data.

  Screenshots (Click to enlarge)

Highslide JS
Select your SQL Server Data Source
Highslide JS
Run your Stored Procedure Exec Command
Highslide JS
Run your Stored Procedure Exec Command

After You've Compared SQL Data With Excel Data

Once you have selected the data you are interested in from SQL Server into Excel you can run local SQL queries on the data.

If you wish to insert new data into your SQL Server Database, or update data you can achieve this by simply selecting your SQL Server Database as your Data Source and then running UPDATE, DELETE or INSERT SQL queries against it.

  "I'm very impressed with this add-in"  -  Dick, Daily Dose Of Excel   


QueryCell  is a Plugin for Excel that  allows you to query using SQL within the Excel application itself.

  • Query Excel Data Using SQL
         Save time by selecting and joining data within Excel
         using SQL, no database required.
  • Query Access, SQL Server, Oracle, MySQL etc From Excel
          Run SQL Selects, Updates, Deletes and Inserts on your database without leaving Excel
  • Generate SQL Insert Statements for Excel Data
          Need to move data from Excel into a database ?
          QueryCell can generate SQL Insert Statements for Excel data in seconds more...
  • Color Rows that match your criteria
          "I want to mark all the rows in worksheet1 where COLUMN_A is greater than COLUMN_B
          in Worksheet2"     It's easy with QueryCell more...
  • Supports Excel 2003, 2007 and 2010
  • QueryCell is Only $45!

    30 day money back guarantee!

  "You've come up with something that genuinely enhances
  Excel's functionality, and I am more than happy to recommend
  it as such"  -  Geoff, Number Cruncher
  "This is a tool any Power Excel User should check out...",
  "I can see this tool saving hours of time"  - BI/BPM - The SeeQueL   


logo