ÿþ<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <link rel="icon" type="image/gif" href="favicon.gif"/> <title>ODBC Data Sources in QueryCell</title> <meta name="description" content="How to connect and query ODBC/DSN data sources from QueryCell" /> <meta name="keywords" content="SQl, Query, ODBC, DSN, QueryCell" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="Robots" content="index,follow" /> <meta name="Robots" content="noodp" /> <style media="all" type="text/css">@import "css/all.css";</style> <SCRIPT LANGUAGE="JavaScript" SRC="js/PopupWindow.js"></SCRIPT> <script type="text/javascript" src="./highslide/highslide-with-gallery.packed.js"></script> <link rel="stylesheet" type="text/css" href="./highslide/highslide.css" /> <script type="text/javascript"> hs.graphicsDir = './highslide/graphics/'; hs.align = 'center'; hs.transitions = ['expand', 'crossfade']; hs.outlineType = 'rounded-white'; hs.fadeInOut = true; //hs.dimmingOpacity = 0.75; // Add the controlbar hs.addSlideshow({ //slideshowGroup: 'group1', interval: 5000, repeat: false, useControls: true, fixedControls: 'fit', overlayOptions: { opacity: .95, position: 'bottom center', hideOnMouseOut: true } }); </script> </head> <body> <div id="feedback" class="feedback-bubbles"> <a href="http://www.querycell.com/feedback.html" onclick="JavaScript: popitup('http://www.querycell.com/feedback.html'); return false;"> <img border="0" src="images/giveFeedbackOrange.png"/> </a> </div> <div id="root-box"> <!-- root-box --> <div id="main-box" > <!-- main-box --> <div id="root"> <!-- root --> <!--<div style="margin-left:30px;"> <table> <tr> <td style="width:280px;"> <a href="http://www.amazon.com/gp/product/0470099518?ie=UTF8&tag=custome09-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=0470099518"><img border="0" src="images/Data-Analysis-Using-SQL-And-Excel.jpg"></a><img src="http://www.assoc-amazon.com/e/ir?t=custome09-20&l=as2&o=1&a=0470099518" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" /> </td> <td style="width:280px;"> <a href="http://www.amazon.com/gp/product/0735640580?ie=UTF8&tag=custome09-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=0735640580"><img border="0" src="images/PowerPivot-For-Excel-2010.jpg"></a><img src="http://www.assoc-amazon.com/e/ir?t=custome09-20&l=as2&o=1&a=0735640580" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" /> </td> <td style="width:280px;"> <a href="http://www.amazon.com/gp/product/B0026OR2TK?ie=UTF8&tag=custome09-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=B0026OR2TK"><img border="0" src="images/Excel-And-Access.jpg"></a><img src="http://www.assoc-amazon.com/e/ir?t=custome09-20&l=as2&o=1&a=B0026OR2TK" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" /> </td> <td style="width:280px;"> <a href="http://www.amazon.com/gp/product/143545751X?ie=UTF8&tag=custome09-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=143545751X"><img border="0" src="images/The-Language-Of-Sql.jpg"></a><img src="http://www.assoc-amazon.com/e/ir?t=custome09-20&l=as2&o=1&a=143545751X" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" /> </td> </tr> <tr> <td colspan="4" style="font-size:12px;"> Books that you may find useful (Click for reviews and pricing on Amazon) </td> </tr> </table> </div> <hr style="width:780px;"/>--> <div id="header"> <!-- header --> <a href="index.html" title="QueryCell">The Power of SQL in Microsoft Excel</a> <h1>Add-In the power of SQL to Microsoft Excel<sup style="font-size:55%;">&#174;</sup></h1> </div> <!-- end header --> <div class="top-menu"> <!-- top-menu --> <ul> <li><a class="menu1" href="index.html">Home</a></li> <li><a class="menu2" href="LearnMore.html">Learn More</a></li> <li><a class="menu3" href="BuyNow.html">Buy Now</a></li> <li><a class="menu4" href="TryNow.html">Try Now</a></li> <li><a class="menu6" href="Support.html">Support</a></li> <li><a class="menu7" href="About.html">About</a></li> </ul> </div> <!-- end top-menu --> <div class="learn-main" style="margin-left:20px;"> <!-- learn-main --> <div class="center-box-orange-block-nf"> <p> <a name="morescreenshots"></a> <h2 class="orange-text">Connecting to External Data Sources </h2> (eg. SQL Server, Access, Oracle, Mysql, Firebird etc) </p> <p><b>(ScreenShots are available below)</b></p> <p> QueryCell has always given you the ability to easily query the data in your excel files using SQL Select statements. As of version 1.4 (released March 2010) QueryCell also makes it easy to query data held in other data sources, such as databases, and bring that data back to excel. </p> <p> In fact QueryCell makes it so easy to retrieve data from databases that once you have set up a query and saved it with your Excel file you can open that file at any time and retrieve the latest results from the database with a single mouse click. </p> </div> <a name="moreimage"></a> <font class="orange-text">&nbsp;&nbsp;Screenshots (Click to enlarge)</font> <br/><br/> <table width="100%" align="center"> <tr align="center"> <td align="center"> <div class="highslide-gallery"> <a href="./images/Full/DataSource1.jpg" class="highslide" onclick="return hs.expand(this)"> <img src="./images/thumbnails/DataSource1.jpg" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> Querying a Database in QueryCell </div> <a href="./images/Full/DataSource2.jpg" class="highslide" onclick="return hs.expand(this)"> <img src="./images/thumbnails/DataSource2.jpg" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> Querying a Database in QueryCell </div> <a href="./images/Full/DataSource3.jpg" class="highslide" onclick="return hs.expand(this)"> <img src="./images/thumbnails/DataSource3.jpg" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> Querying a Database in QueryCell </div> </div> <!-- end gallery --> </td></tr> </table> <div class="center-box-orange-block-nf"> <h2 class="orange-text"> Reloading Database Data With a Single Click </h2> <p> When you run a query against a database data source QueryCell inserts a header comment such as : </p> <p><b> /*<br/> QC DB Query<br/> Query Name (Worksheet to put results in) - QueryResults<br/> Data Source (ODBC DSN name) - mysql test<br/> */</b> </p> <p> That header comment tells QueryCell which Data Source Name to run the Query Against. </p> <p> By saving the query in the Excel file (by checking the 'Save SQL' checkbox and saving the Excel file), or by dragging the query text into the SQL library the query will be available next time you open the excel file. So you simply click the 'Run SQL' button and the latest available data will be retrieved from your database and brought into Excel. </p> </div> </div> <!-- end learn-main --> </div> <!-- end root --> </div> <!-- end main-box --> <br/><br/> <div class="bottom"> <!-- bottom --> <a class="logo2" href="index.html">logo</a> <ul> <li class="none"><a href="index.html">Home</a></li> <li><a href="LearnMore.html">Learn More</a></li> <li><a href="BuyNow.html">Buy Now!</a></li> <li><a href="TryNow.html">Try Now</a></li> <li><a href="Support.html">Support</a></li> <li><a href="About.html">About</a></li> </ul> </div> <div class="bottom"> <ul> <li>Copyright Oak Focus Software / QueryCell 2010 (All Rights Reserved).</li> </ul> <ul> <li>Microsof Excel&#174; is a trademark of Microsoft Corporation.</li> </ul> <ul> <li>The QueryCell Product and its website are not associated with Microsoft Corporation</li> </ul> </div> </div> <!-- end root-box --> <!--</div> end root --> <!--</div> <!-- end main-box --> <!--</div> <!-- end root-box --> <script type="text/javascript"> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); </script> <script type="text/javascript"> try { var pageTracker = _gat._getTracker("UA-8826822-1"); pageTracker._trackPageview(); } catch(err) {} </script> </body> </html>