We also have users making excel tables available to SAS and we push the responsibility to the end user to comply with the agreed format. As such we have a stored process which the user can use to upload the excel (csv) and upon receipt we check the format (e.g. date is correct, correct delimiter....) If OK, then we process it, if not then we return a html to the user telling him that the format is not according to the agreed format. Very simple and effective to ensure that the data is correctly delivered. Maybe not an answer to your question, but it might give another view on the problem.
... View more