In article . com,
wrote:

I am importing two .csv files from an Oracle table into a workbook:
SalesRep, MainRep

Column A: is Bank
Column B: is Rep Name
Column C: is Branch #
Columns N:R contain data.

The process is to compare the MainRep page to the SalesRep page.
So for each row on the MainRep page, If the Bank and Rep Name and
Branch #, are
found on the SalesRep page, do nothing, else, add the entire row to the
SalesRep page.

this was ok when i tested with my data, however, the oracle table results
are 17,000 records, and it takes a long time to process. Any idea on a
better way to compare these values? any help would be greatly
appreciated.

Can you do the Join in a temporary table in Oracle, then read that table
into your spreadsheet? In general, a database will be faster at doing a
join than a spreadsheet will.

--
Randy Hudson