Excel 2007 Oracle DB Help

M

m.devita

Heres the breakdown. I have an oracle db named MXFP and the server is
named MXFP. I use a msquery to pull data from the GLaccounts table.
which returns 1131 rows of data.

I need to build something to retreive all information from another
table named workorders for each of these GLaccount rows.

IE:

SELECT * FROM WORKORDERS WHERE GLACCOUNT=A1


A1 = Cell a1 of the GLaccounts sheet.

Not sure how i can go about this. Ive tried using sql.request but i
cant build the friggin script properly and i cant find XLODBC.XLA add-
in for 2007.

Any help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top