Hi,

Can anyone help me please with a data validation issue. I have a set
of Oracle Tables which are being used in a PeopleSoft Financials
system. There is a requirement to validate all data being input into
an Excel Spreadshet against these Oracle Tables. What would be the
best way of doing this? I have looked at the Data Validation option
within Excel but the volumes of data we are talking about here makes
it not possible.
It would also be nice to create a report (maybe txt file) showing
where, if any, there were errors


Any help would be gratefuly apprecitated.


Richard

Sounds like you should be using the V or H lookup function....

On Aug 14, 12:22 pm, richard.good...@gmail.com wrote:
> Hi,
>
> Can anyone help me please with a data validation issue. I have a set
> of Oracle Tables which are being used in a PeopleSoft Financials
> system. There is a requirement to validate all data being input into
> an Excel Spreadshet against these Oracle Tables. What would be the
> best way of doing this? I have looked at the Data Validation option
> within Excel but the volumes of data we are talking about here makes
> it not possible.
> It would also be nice to create a report (maybe txt file) showing
> where, if any, there were errors
>
> Any help would be gratefuly apprecitated.
>
> Richard