I am doing a bulk insert on a web page to a sql server (via a browse and upload button) and currently when a user supplies a file thats in an incorrect format, we simply return them a message stating that it is in incorrect format but what I would like to be able to do is to append a leading comma if the file is missing it, be able to determine if all the fields in the database are there (and drop the tables if there are additional fields in the file that is being uploaded) and also convert the date to a the sql format of yyyymmdd:hh:mm if its not in that format. Does anyone have any kind of script written that already does this kind of thing?
Thank you
Doug