Hi, this is probably a basic question for some of guru's out there. But I'm trying to migrate data (2,500 records) from an MS Access database to an MS Excel database and also to a inhouse database. Would any one know of any VBA code I could use to migrate this data to both packages? Thanks! :-)© 2009 Microsoft Corporation. All rights reserved.Tue, 14 Jul 2009 07:36:23 Z37136500-1f8b-4b69-a2be-cce92f3d0e3dhttp://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/37136500-1f8b-4b69-a2be-cce92f3d0e3d#37136500-1f8b-4b69-a2be-cce92f3d0e3dhttp://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/37136500-1f8b-4b69-a2be-cce92f3d0e3d#37136500-1f8b-4b69-a2be-cce92f3d0e3dExcited4VBAhttp://social.msdn.microsoft.com/Profile/en-US/?user=Excited4VBAHi, this is probably a basic question for some of guru's out there. But I'm trying to migrate data (2,500 records) from an MS Access database to an MS Excel database and also to a inhouse database. Would any one know of any VBA code I could use to migrate this data to both packages? Thanks! :-)Thu, 09 Jul 2009 07:12:23 Z2009-07-09T07:12:23Zhttp://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/37136500-1f8b-4b69-a2be-cce92f3d0e3d#6466e571-5510-4743-9c4f-6951f1cf3037http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/37136500-1f8b-4b69-a2be-cce92f3d0e3d#6466e571-5510-4743-9c4f-6951f1cf3037kaymafhttp://social.msdn.microsoft.com/Profile/en-US/?user=kaymafThis is VB.net forum, for VBA, try its forum at <a href="http://social.msdn.microsoft.com/forums/en-US/isvvba/threads/">http://social.msdn.microsoft.com/forums/en-US/isvvba/threads/</a> <br/>kaymaf<hr class="sig">I hope this helps, if that is what you want, just mark it as answer so that we can move on Thu, 09 Jul 2009 12:57:49 Z2009-07-09T12:57:49Zhttp://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/37136500-1f8b-4b69-a2be-cce92f3d0e3d#ec456e40-e144-4ed0-94ef-8f166599ec74http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/37136500-1f8b-4b69-a2be-cce92f3d0e3d#ec456e40-e144-4ed0-94ef-8f166599ec74Reed Kimblehttp://social.msdn.microsoft.com/Profile/en-US/?user=Reed%20KimbleMoved to VBA Forum from VB Language...<hr class="sig">Reed Kimble - &quot;When you do things right, people won't be sure you've done anything at all&quot;Thu, 09 Jul 2009 15:42:28 Z2009-07-09T15:42:28Zhttp://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/37136500-1f8b-4b69-a2be-cce92f3d0e3d#80066193-064e-4b46-a1b3-5055b009e12dhttp://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/37136500-1f8b-4b69-a2be-cce92f3d0e3d#80066193-064e-4b46-a1b3-5055b009e12dADGhttp://social.msdn.microsoft.com/Profile/en-US/?user=ADG<p>Hi, easiest way to get data into excel is to use a query on one of your sheets that will refresh on open. If you want to use vba you can use AODB to get a recordset and the copyfromrecordset method. In terms of your inhouse database you will need to find out what import functionality this has and the necessary file format.<br/><br/>Regards<br/><br/>ADG</p>Thu, 09 Jul 2009 16:24:40 Z2009-07-09T16:24:40Zhttp://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/37136500-1f8b-4b69-a2be-cce92f3d0e3d#7c616473-b697-4e93-8591-4a2cb8b33670http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/37136500-1f8b-4b69-a2be-cce92f3d0e3d#7c616473-b697-4e93-8591-4a2cb8b33670Excited4VBAhttp://social.msdn.microsoft.com/Profile/en-US/?user=Excited4VBAThanks! :-)Thu, 09 Jul 2009 18:52:26 Z2009-07-09T18:52:26Zhttp://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/37136500-1f8b-4b69-a2be-cce92f3d0e3d#a863cf57-2fa5-44c9-9829-ac288491d6c1http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/37136500-1f8b-4b69-a2be-cce92f3d0e3d#a863cf57-2fa5-44c9-9829-ac288491d6c1Excited4VBAhttp://social.msdn.microsoft.com/Profile/en-US/?user=Excited4VBAThanks! :-)Thu, 09 Jul 2009 18:52:46 Z2009-07-09T18:52:46Z