Search results

Don't worry Banana, reallly appreciating your assistance :) well, I will explain what i am trying to do, it might help.. I am trying to create a small application in access, with two buttons, one button imports data from oracle into the access table (based on an SQL query), then the other...

well, I am quiet comfortable with the manual process, I've been importing/exporting table into and from access for a while now and, I want to take it to the next level and automate the process :)

Thanks Banana, actually thats exactly what i needed to do.. (query oracle database from access and import the data into the access database..) do you have any links where i can find extra information on the same ? or sample codes ? :o I am a newbie to access

Thanks Ron_dK for your reply, unfortunately the links are for ORACLE emp/exp commands.. I need VBA commands, to import data into access database

Thanks alot, the secound link is exactly what i needed :) is there a link that describes the import commands from oracle to access and how to use them ?

Dears, I am trying to create a VBA application which has a button that imports data from oracle database. I searched the net on how to connect to oracle via VBA, and execute the import but couldnt find anything :( Can anyone help ? And is there a link that describes the import commands...

Thanks DCrake for your reply, well, the data i am trying to import is in an oracle 9 database. and i am not using DTS coz i need to import the data at a certain stage that cannot be scheduled. and this can happen more than once a day with no exact timing.

Dear all, I am a newbie to access and VBA :eek:, and trying to create a small VBA application that imports certain data (based on an sql statement) to access table. then export the same to a microsoft sql server. Can anyone help :confused: ? or send me links where i can get information on...