M
Mark
Hi all,
Shot in the dark here. We have queries that we run in an iSeries app on an
AS400 db. What we're doing now is translating the iSeries queries into SQL
and then connecting to the AS400 db via ODBC connection in Access. Thing is,
more people here are comfortable with building queries on iSeries than with
SQL (even though I personally find SQL easier myself).
So, my question is whether there's a way using Access VBA (and an iSeries
API, I guess) to change parameters and execute an existing iSeries query the
results of which I can then download. I've read some articles on how to do
it, but nothing that I can seem to build off of. They leave things such as
how to declare objects, what references to include, etc.
Any help appreciated. Thanks!
Shot in the dark here. We have queries that we run in an iSeries app on an
AS400 db. What we're doing now is translating the iSeries queries into SQL
and then connecting to the AS400 db via ODBC connection in Access. Thing is,
more people here are comfortable with building queries on iSeries than with
SQL (even though I personally find SQL easier myself).
So, my question is whether there's a way using Access VBA (and an iSeries
API, I guess) to change parameters and execute an existing iSeries query the
results of which I can then download. I've read some articles on how to do
it, but nothing that I can seem to build off of. They leave things such as
how to declare objects, what references to include, etc.
Any help appreciated. Thanks!