Migrating data from MS Access to MS Excel using VBA code...calling all VBA Experts!!

Question

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! :-)

Answer 1

This is VB.net forum, for VBA, try its forum at http://social.msdn.microsoft.com/forums/en-US/isvvba/threads/
kaymaf

---

I hope this helps, if that is what you want, just mark it as answer so that we can move on

Answer 2

Moved to VBA Forum from VB Language...

---

Reed Kimble - "When you do things right, people won't be sure you've done anything at all"

Answer 3

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.

Regards

ADG

Answer 4

Thanks! :-)

Answer 5

Thanks! :-)