VBA application to import data to access, then export to sql server

[DVL]

Dear all,

I am a newbie to access and VBA , 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 ? or send me links where i can get information on how to do the database connections, and commands to import and export the data ?

Thanks alot

 

[DCrake]

Where is the source data coming from?
Why cant you get SQL to run a DTS package to import the data directly in to SQL?

 

[DVL]

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.