automate export oracle tables to microsoft access format

[fatchoy]

I am running oracle 7.3 on unix 10.2

I doing manual export of oracle tables to
microsoft access monthly.

Is there a way for me to automate this process by scripts or third party software?

Thks in advance

 

[Junior1544]

well, you can make a command button in access do this for you, you will just need to code it in vb... and then put it into the on click event on the form...

you can even automate it even more if you want to... make it do every thing it needs to in a query, then just run access with a command line switch to run the query, and put that into windows (or another one) scheduler... and that will realy automate it for you... hope this helps...

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[WildHare]

I may be wrong, but I think Access might have a little problem knowing about the Oracle database running over on that Unix box...or is ODBC that smart???

I believe that MOST of your work is going to have to be done on the Unix box - and I'm clueless there. Check the Oracle forums here, if you haven't already.



There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[Junior1544]

thanks, i must have read that wrong... i thought he meant a copy from the unix box into access... my mistake...

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.