karmaimages
Board Regular
- Joined
- Oct 1, 2009
- Messages
- 112
- Office Version
- 365
- Platform
- Windows
I’m looking to do a lookup from Excel to an Oracle DB<o
></o>
<o></o>
Normally I’d just look up the list using a quick bit of SQLand export the results to Excel to analyse however, there are over 10k rows tolookup and the limit for the SQL is 1000 <o></o>
<o></o>
Column 1 contains the list of customer numbers, which I need tolookup in the DB to find their reference number within a back office system. <o></o>
<o></o>
Column 1 is called Ref1<o></o>
<o></o>
The Table in the db is called data.ref_pol<o></o>
<o></o>
Fields to lookup in the table are REF1 and Ref 2<o></o>
<o></o>
Looking up the following where Excel Ref1 = DB Ref1 what isRef2 <o></o>
<o></o>
Hopefully this will make sense?<o></o>
></o><o
></o>Normally I’d just look up the list using a quick bit of SQLand export the results to Excel to analyse however, there are over 10k rows tolookup and the limit for the SQL is 1000 <o
></o><o
></o>Column 1 contains the list of customer numbers, which I need tolookup in the DB to find their reference number within a back office system. <o
></o><o
></o>Column 1 is called Ref1<o
></o><o
></o>The Table in the db is called data.ref_pol<o
></o><o
></o>Fields to lookup in the table are REF1 and Ref 2<o
></o><o
></o>Looking up the following where Excel Ref1 = DB Ref1 what isRef2 <o
></o><o
></o>Hopefully this will make sense?<o
></o>
Last edited:
