Excel Data To SQL Server

(ScreenShots are available below)

It is very easy to get Excel data into SQL Server database tables.

1. Select the data in Excel you want to move into SQL Server.

2. On the Right Click menu select 'QC - SQL Inserts'.

3. Modify the Generator SQL to customize the Insert Statements generated.

3. Copy the Insert Statements into the SQL editor and click 'Run SQL'.

And you're done, your Excel data is now in your SQL Server table.

  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 Moved Your Excel Data Into SQL Server

QueryCell will tell you how many rows were inserted but you can of course query the SQL Server database yourself, from within Excel (using QueryCell) to check.

  "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