ÿþ<!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>Microsoft Access Into Excel</title> <meta name="description" content="Microsoft Access Data Into Excel" /> <meta name="keywords" content="Microsoft Access, Access, Excel, SQL, Export, Import" /> <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="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" style="line-height: 34px;">Microsoft Access Into Excel</h2> </p> <p><b>(ScreenShots are available below)</b></p> <p> You can get Microsoft Access data into an Excel spreadsheet easily using QueryCell. </p> <p> 1. Select your Access database from the Data Sources drop down box. </p> <p> (If you haven't defined an ODBC connection to your database you can do so by clicking on the ODBC+ icon) </p> <p> 2. Check the Access DB Check Box. </p> <p> 3. Write the SQL Select statement that will retrieve the data into the SQL Editor and click the Run SQL button. </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/QC_ScreenShots/T7_SS1_900_600.png" class="highslide" onclick="return hs.expand(this)"> <img src="./images/QC_ScreenShots/T7_SS1_340_270.png" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> Select your Access database. You can define an ODBC connection to an Access database by clicking on the ODBC+ icon </div> <a href="./images/QC_ScreenShots/T7_SS2_900_600.png" class="highslide" onclick="return hs.expand(this)"> <img src="./images/QC_ScreenShots/T7_SS2_340_270.png" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> Enter your SQL and click the Run SQL Icon </div> </div> <!-- end gallery --> </td></tr> </table> <div style="margin-left:7px;"> <div class="testimonial-box" style="margin-left:5px;"> &nbsp;&nbsp;"I'm very impressed with this add-in" &nbsp;-&nbsp; Dick, <a style="color: #D27302;" target="_blank" href="http://www.dailydoseofexcel.com/archives/2009/10/05/querycell/">Daily Dose Of Excel</a>&nbsp;&nbsp;&nbsp; </div> <!-- <div class="center-box-white-block-nf-np" style=""> <span class="orangeTitleText" style="color: #FC9200; font-size: 1.1em; text-align:center; background-color: #BDD4ED;">&nbsp;&nbsp;&nbsp;&nbsp;No SQL Server Required. QueryCell is a complete solution. Query with SQL in Excel!&nbsp;&nbsp;&nbsp;&nbsp;</span> </div> --> <br/><br/> <!-- <a href="LearnMore.html#moreimage"><img src="images/display.jpg" width="255" height="24" alt="" border="0"/> --> <img src="images/displayNoText.jpg" width="255" height="24" alt="" border="0"/> <!--</a>--> <div class="right-box"> <!-- right-box Screen and text --> <!--<h2 style="padding: 0 0 10px 0;">--> <p class="orangeTitleText"><em style="color: #20688D;">Query</em><em style="color: #0B3F5A;">Cell</em>&nbsp;&nbsp;is&nbsp;a Plugin for Excel&nbsp;that&nbsp; allows you to query using SQL within the Excel application itself.</p> <!--</h2>--> <ul> <li style="padding: 0 0 10px 0;"><b>Query Excel Data Using SQL</b><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Save time by selecting and joining data within Excel<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;using SQL, no database required.</li> </ul> </div> <!-- end right-box Screen and text --> <div class="cent-links"> <ul > <li style="padding: 0 0 10px 0;"><b>Query Access, SQL Server, Oracle, MySQL etc From Excel</b><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Run SQL Selects, Updates, Deletes and Inserts on your database without leaving Excel</li> <li style="padding: 0 0 10px 0;"><b>Generate SQL Insert Statements for Excel Data</b><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Need to move data from Excel into a database ? <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;QueryCell can generate SQL Insert Statements for Excel data in seconds <a style="color: #D27302;" href="SQLGenerator.html">more...</a></li> <li style="padding: 0 0 10px 0;"><b>Color Rows that match your criteria</b><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<i>"I want to mark all the rows in worksheet1 where COLUMN_A is greater than COLUMN_B <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; in Worksheet2"</i> It's easy with QueryCell <a style="color: #D27302;" href="ColorRows.html">more...</a></li> <li style="padding: 0 0 10px 0;">Supports Excel 2003, 2007 and 2010</li> <li style="padding: 0 0 10px 0;">QueryCell is Only $45!<p class="orangeTitleText">30 day money back guarantee!</p></li> </ul> </div> <div style="float: left;width:300px;margin-left: 40px; margin-top: 20px; margin-bottom: 20px; padding: 0;"> <!--<a class="buy-now-but" href="BuyNow.html">buy-now</a>--> <a class="download-but" href="downloadPopup.html" onclick="JavaScript: popitup('downloadPopup.html'); return false;">download trial</a> </div> <div style="float: right;width:300px;margin: 0px 0px 0px 0px; margin-top: 20px; margin-bottom: 20px; padding: 0;"> <!--<a class="buy-now-but" href="BuyNow.html">buy-now</a>--> <a class="buy-front-but" href="https://sites.fastspring.com/oakfocus/instant/querycell">Buy Now</a> </div> <div class="testimonial-box" style=""> &nbsp;&nbsp;"You've come up with something that genuinely enhances <br/>&nbsp;&nbsp;Excel's functionality, and I am more than happy to recommend<br/>&nbsp;&nbsp;it as such" &nbsp;-&nbsp; Geoff, <a style="color: #D27302;" target="_blank" href="http://excelicious.wordpress.com/2010/03/16/querycell-sql-in-excel/">Number Cruncher</a> </div> <div class="testimonial-box" style=""> &nbsp;&nbsp;"This is a tool any Power Excel User should check out...", <br/>&nbsp;&nbsp;"I can see this tool saving hours of time" &nbsp;-&nbsp;<a style="color: #D27302;" target="_blank" href="http://sqlrs.blogspot.com/2010/03/querycell-review-and-license-giveaway.html">BI/BPM - The SeeQueL</a>&nbsp;&nbsp;&nbsp; </div> </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> <!-- HitTail Code --> <script type="text/javascript"> (function(){ var ht = document.createElement('script');ht.async = true; ht.type='text/javascript';ht.src = '//92956.hittail.com/mlt.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ht, s);})(); </script></body> </html>