View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1,560
Default 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