Database Inserts Updates Deletes From Excel

(ScreenShots are available below)

Running SQL statements, including SELECTS, UPDATES, DELETES and INSERTS, on a database from Excel is easy.

1. Make sure you are connected to the database by selecting it from the Data Sources drop down box.

(If you haven't defined an ODBC connection to your database you can do so by clicking on the ODBC+ icon)

2. Enter the SQL statements you wish to run into the SQL Editor and click the Run SQL button.

(if you wish to run SQL Insert statements don't forget that QueryCell can generate them for you, just select the data and select "QC - SQL Inserts" from the menu).

  Screenshots (Click to enlarge)

Highslide JS
Select your database
Highslide JS
Enter your SQL and click the Run SQL Icon

I can query a database using SQL from Excel, can I query Excel data using SQL also ?

You sure can!

If you select '- Excel Data Regions -' from the Data Sources drop down box you will be able to run SQL statements agains the data in your Excel file.

The Regions grid to the left of the SQL Editor contains a list of the regions of data that are available to query in Excel. You can manually add new regions or refresh the grid and have QueryCell automatically search for new data regions.

  "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