View Single Post
  #7 (permalink)  
Old January 19th, 2005, 03:06 PM
echovue echovue is offline
Friend of Wrox
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts

If you can write VB then VBA is a cakewalk. There are a few differences, but all in all it is much the same.

I am assuming that you have a form, and the user will push a button to import the tables. On the properties for the button, goto the Events and click the ... next the the onClick event. Access should give you three options, select 'Code Builder' and it should take you to the VBA module associated with that form. I haven't imported tables using VBA before, but I have seen it done. I think all that you would need to set up a connection to the Oracle Instance, and then if I am not mistaken, there is a TransferDatabase method or something similar that you could use to pull the tables in. I would be happy to try point you in the right direction if you need more help.

Reply With Quote