How To Generate SQL Insert Statement from Excel - QueryCell
blogger tips 11:52 AM
QueryCell is a Plugin for Excel that allows you to query using SQL within the Excel application. It Supports Excel 2003, 2007 and 2010 also. It has the ability of Generating SQL Insert Statements for Excel Data. The SQL Generator comes free with QueryCell and allows you to generate SQL insert statements for excel data in seconds.
- First Download QueryCell. No need to give your email address.
- Close all running Microsoft Office Applications (word, excel,access, etc) and then run the QueryCell.exe file you have downloaded.
- Once the installation is complete open Microsoft Excel and you should see the QueryCell Icon on the Excel Menu.
- To open QueryCell in Microsoft Excel 2007 Click the QueryCell Tab and then the Open and Close Icon.
- QueryCell requires Windows XP or Vista and Microsoft Excel 2003 or Mircorosft Excel 2007.
Steps to follow To Generate SQL Insert Statement from Excel.
Step 1. Select the data and Click the 'SQL Inserts' Right Click Menu Item.
Step 2. SQL Inserts Will be presented in a popup window.
Step 3. You can
- Change the TARGET table name
- Modify column names
- Have some column values in quotes and others not
- Using simple Search and Replace (as shown in this slide)
- By Modifying the Generator SQL (as shown in the next slide)
Step 4. The 'View Generator SQL' button allows you to see the SQL that is being used to generate the SQL Insert statements.
You can modify this SQL and then press the 'Regenerate the SQL Inserts Icon to generate the SQL with your modifications.
- This application is comes with 30 days License and if you want to purchase then price is $45.
So do you like this tool or not ??
If you like this post or this post has helped you in anyway, please click the +1 button below to recommend this page and support our website.
You can follow us on Twitter or join our Facebook Fan Page for more updates like this .
Posted by Chaitu
on 11:52 AM.
Filed under
blogger tips
.
You can follow any responses to this entry through the RSS 2.0