ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Howto use excel cell value to lookup an oracle table (https://www.excelbanter.com/excel-discussion-misc-queries/20566-howto-use-excel-cell-value-lookup-oracle-table.html)

Andre

Howto use excel cell value to lookup an oracle table
 
I have an excel worksheet containing a list of userid's in
cell A, for each row I want to reference the userid in
cell A and connect to an external Oracle database to
lookup and return further details for that user.

eg.. their department and location etc..

Can you advise how I do this.

I am currently using Excel 2003


All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com