Validate Data Against An Excel Document

[LyLy]

Hello,

I was wondering if it is possible to validate information entered in a
InfoPath 2003 form against an Excel document? The Excel document could have
hundreds or thousands of lines of data and what is entered in the form must
be listed in the Excel document, if it is not a message should tell the user
that their selection is invalid. If so, how do I set up the validation in
the form?

 

[Greg Collins]

I believe you can export your Excel document as XML and then establish a
data connection to that XML file, read it in, and walk through it (using
code) to see if there is a match.

 

[LyLy]

Thanks Greg,
Would you be able to point me to detail instructions on how to do this via
code? Any further information would be greatly appreciated.

Thanks again,
LyLy

 

[Greg Collins]

If you are familiar with coding practices in relation to the main DOM, then
this should be easy for you--its just a matter of reading from the secondary
DOM instead of the main DOM.

I not, I don't have any specific site to point you to. You'll need to find
something in the coding language you are familiar with, though, to make it
easier to understand what they are doing.