M
marfi95
Hi all,
I'm trying to automate an import of a single table from an oracle 9i
database on the backend to a local table in Access 2003 (not linked
table). I'd like to do this either from a macro or vba code to keep
the users from having to go through the steps of getexternal,
import.... Plus I just want a single table, and they shouldn't have
to pick the table,etc...
Also, I don't want all the data to be brought down. I need it to be
based on an sql that the user will supply parameters for. i.e. they
will enter a start and end date.
I'd like to go through ODBC to get the data, but haven't really found
any good examples to go on connecting, retrieving data and inserting
into the local access table.
Can someone provide a small example of how to do this or point me to a
good location to get started ?
Many thanks !
Mark
I'm trying to automate an import of a single table from an oracle 9i
database on the backend to a local table in Access 2003 (not linked
table). I'd like to do this either from a macro or vba code to keep
the users from having to go through the steps of getexternal,
import.... Plus I just want a single table, and they shouldn't have
to pick the table,etc...
Also, I don't want all the data to be brought down. I need it to be
based on an sql that the user will supply parameters for. i.e. they
will enter a start and end date.
I'd like to go through ODBC to get the data, but haven't really found
any good examples to go on connecting, retrieving data and inserting
into the local access table.
Can someone provide a small example of how to do this or point me to a
good location to get started ?
Many thanks !
Mark