Export access query into oracle table

[tinoco]

Hi!!

i need to export a access query from microsoft access 2003 into a oracle table using vba code or a macro.
How can i do it?

thanks

 

[PHV]

Why not using an append query with a linked table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tinoco]

hi!
because i will create a table everytime that i run the query.
i want to fill up a oracle table everytime that i run the access query.
i have created a odbc conection that allows me to do it but i have to go from the top menus like file\export\odbc databases... and i want to do it from my application form!
do you have any suggestion?

thanks a lot