Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Oracle DB Help
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Oracle Extract in Excel 2007 causes processor to run at 100% | Excel Discussion (Misc queries) | |||
XL 2007 lose formats when opening file exported from Oracle Discov | Excel Discussion (Misc queries) | |||
Exporting Data from Oracle 11i to XL 2007 (TSV) | Excel Discussion (Misc queries) | |||
Excel 2007 used with Oracle ADI | Excel Programming | |||
Connect to Oracle using Microsoft ODBC for Oracle | Excel Programming |