how to validate excel spreadsheets
You need to define the fields you are bringing in and the type of data you
expect to be bringing in, then it would help to know the number of records
that you are expecting. Where is this data coming from, what is the source?
--
David
"Mason" wrote:
Hi guys
I am developing a document management solution in which some data will be
received as an xl spreadsheet that complies to a certain pre-defined
template/format (headings,datatypes etc) that maps to database columns where
the data will eventually be saved.How can I go about this also taking into
account that during validation all errors must be logged and routed to the
respective stakeholders
Please Help
|