M
Mark Olsen
Hi, I am wanting to connect to an oracle 8.1 database so that I can send raw
SELECT queries to retrieve specific information. I am already connected
through ODBC and have been using the design grid to construct queries but I
need more complex queries that it can let me do. I also tried pass through
queries which are great but I want to have variable parameters for the query
which it does not look like I can do. Also, after I retrieve the info then I
want to export it to Excel. Ive heard about ODBCdirect. Will this do what I
need? Will it allow me to create a form in VBA to enter the parameters of
the query? I was thinking I would just do this by string manipulation. What
about DAO vs ADO. Im not too familier with access specific VBA but im
learning. Thanks
SELECT queries to retrieve specific information. I am already connected
through ODBC and have been using the design grid to construct queries but I
need more complex queries that it can let me do. I also tried pass through
queries which are great but I want to have variable parameters for the query
which it does not look like I can do. Also, after I retrieve the info then I
want to export it to Excel. Ive heard about ODBCdirect. Will this do what I
need? Will it allow me to create a form in VBA to enter the parameters of
the query? I was thinking I would just do this by string manipulation. What
about DAO vs ADO. Im not too familier with access specific VBA but im
learning. Thanks