ÿþ<!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 Excel Into Access</title> <meta name="description" content="Excel Data Into Access" /> <meta name="keywords" content= "Excel, Access, SQL, Data" /> <meta http-equiv="Content-Type" content= "text/html; charset=us-ascii" /> <meta name="Robots" content="index,follow" /> <meta name="Robots" content="noodp" /> <!--<style media="all" type="text/css">@import "css/all.css";</style>--> <link rel="stylesheet" type="text/css" href="./css/all.css" /> <script language="JavaScript" src="js/PopupWindow.js" type= "text/javascript"> </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"> //<![CDATA[ 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> <div id="root-box"><!-- root-box --> <div id="main-box"><!-- main-box --> <div id="root"><!-- root --> <div id="header"><!-- header --> <a href="index.html" title="QueryCell">The Power of SQL in Microsoft Excel</a> <h1>The power of SQL in Microsoft Excel<sup style= "font-size:55%;">&reg;</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;"><!-- main --> <table width="100%" border="0" style="margin-left:8px;"> <tr align="center"> <td colspan="2"><font class="orange-text">Getting Excel Data Into Access<br/> In 2 minutes<br /> &nbsp;</font></td> </tr> <tr><td> This tutorial shows how you can get your data from Excel into Access in a couple of minutes. </td> </tr> <tr> <td>&nbsp;</td> </tr> </table> <div class="box-orange-block-border"><!-- Start Guide Item Div --> <div style="margin-left:8px;"> <OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,28;" WIDTH=680 HEIGHT=504><PARAM NAME=movie VALUE="Excel-To-Access_toolbar.swf"> <PARAM NAME=quality VALUE=high> <PARAM NAME=bgcolor VALUE="#FFFFFF"><param name="allowFullScreen" value="true" ><EMBED src="Excel-To-Access_toolbar.swf" allowfullscreen="true" quality=high bgcolor="#FFFFFF" WIDTH=680 HEIGHT=504 TYPE="application/x-shockwave-flash" PLUGINSPAGE="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></EMBED></OBJECT> </div> <p> <b>Transcript</b> </p> <p> Hey there, </p> <p> I've got some data inside Excel that I'd like to get into Access. It's pretty simple using QueryCell, it only takes a couple of minutes. </p> <p> Firstly I select the data I am interested in and right click. On the right click menu I select 'SQL Inserts'. QueryCell with then generate a SQL insert statement for each row I've selected. </p> <p> Now I'm going to want to make a couple of changes to these insert statements. I'm going to want to change the name of the target table and I'm going to want to specify that the first column, which is a number not text, should not be wrapped in single quotes. </p> <p> In order to do that I simply view the generator SQL and modify the name of the target table and the single quotes that wrap around the first column. </p> <p> Now that I've done that I simply re-generate my inserts. Excellent, now by clicking on the 'Copy To Clipboard' icon all these insert statements are now available in my clipboard so I could go to Access and paste them in. </p> <p> However I don't need to. Because my Access database is set up as an ODBC data source I'm able to connect to it directly from QueryCell from within Excel. I've now connected up to my Access database and pasted in my insert statements into the SQL editor. </p> <p> Now when I click 'Run SQL' those inserts are run against the database. I've just inserted my 25 rows. </p> <p> It's as simple as that. </p> <p> I've just moved my data from Excel into Access. Let's check. </p> <p> There we go, these are the rows I've just inserted into my Access database. </p> <p> It's that simple. </p> <p><b>Please contact us at <a style="color: #D27302;" href="mailto:support@querycell.com">support@querycell.com</a> if you have any questions or suggestions about this tutorial.</b> </p> <!-- End Guide Item Div --> <!-- End main--> </div> <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&reg; 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> <!-- end bottom --></div> </div> <!-- end root --></div> <!-- end main-box --></div> <!-- end root-box --> <script type="text/javascript"> //<![CDATA[ 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"> //<![CDATA[ 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>