Data Validation using excel spreadsheet

DavidCantor

Registered User.
Local time
Today, 11:41
Joined
Oct 4, 2012
Messages
66
How can I validate data using an excel spreadsheet?
i have a table with Product information, I want only the ProductId that are in the spreadsheet to be used in the database. How can I check the ProductID entered in the form actually exists in the excel spreadsheet?
 

Users who are viewing this thread

Back
Top Bottom