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

Similar Threads

How to find record in Oracle 0
Exporting from Excel to Access DB 2
Access 2007 VBA: Error handler importing an Oracle table 0
Exporting data with vba from Excel to an Access 2007 db with password 8
Linking to Oracle 5
Macro to Format Multiple Sheets based on "Master" Format 0
Changing Oracle connection from DSN to DSN-Less 3
SQL ODBC MSQuery in EXCEL 1

Top