ÿþ<!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>Getting Data From Access Into Excel</title> <meta name="description" content="Getting Microsoft Access Data Into Excel" /> <meta name="keywords" content="Microsoft Access, Microsoft Excel, Export, SQL, Data" /> <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;">Getting Data from Microsoft Access into Microsoft Excel</h2> </p> <p><b>(ScreenShots are available below)</b></p> <p> There are a number of ways to get Access data into Excel and vice versa. Here is an example of one of the easiest ways. </p> <p> Using QueryCell we can simply connect to the Access database and SELECT the data we are interested in directly from Excel. </p> <p> 1. Define an ODBC connection to your Access database. You can do this by simply clicking on the ODBC+ icon within Excel or by going to Control Panel -> Administrative Tools -> Data Sources. </p> <p> 2. Select the data source from the Data Source drop down box. </p> <p> 3. Write your SELECT query in the SQL editor and Click the Run SQL button. </p> <p> 4. The data will be returned to the QueryResults worksheet. Rename this worksheet if you wish to keep the data (so that it will not be overwritten the next time you run a query). </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/T8_SS1_900_600.png" class="highslide" onclick="return hs.expand(this)"> <img src="./images/QC_ScreenShots/T8_SS1_340_270.png" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> Select your database </div> <a href="./images/QC_ScreenShots/T8_SS2_900_600.png" class="highslide" onclick="return hs.expand(this)"> <img src="./images/QC_ScreenShots/T8_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> <a href="./images/QC_ScreenShots/T8_SS3_900_600.png" class="highslide" onclick="return hs.expand(this)"> <img src="./images/QC_ScreenShots/T8_SS3_340_270.png" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> QueryCell can generate SQL Inserts in seconds </div> <a href="./images/QC_ScreenShots/T8_SS4_900_600.png" class="highslide" onclick="return hs.expand(this)"> <img src="./images/QC_ScreenShots/T8_SS4_340_270.png" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> QueryCell can generate SQL Inserts in seconds </div> </div> <!-- end gallery --> </td></tr> </table> <div class="center-box-orange-block-nf"> <h2 class="orange-text" style="line-height: 34px;"> What if I want to manipulate the data in Excel and run SQL against it ? </h2> <p> You can do this easily in QueryCell. Once you have the data you need in Excel simply select '- Excel Data Regions -' from the Data Sources drop down box. </p> <p> You can refresh the regions by clicking the refesh icon above the Regions Grid. </p> <p> You are then able to run SQL queries against the Excel data regions as though they were tables in a relational database. </p> </div> <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>