File UPload to DATABASE

Hi all,

Is it possible to upload a excel file so that the content in the excel file will be automatically imported into my “SQL Server” database…

As my solution demands that I am getting some excel sheets on daily basis and I don’t want to use the SQL Server import utility to import all that data in to the server. as this is done by the sales people, I don’t want to explain the “SQL Server” to them.
so does any body has any suggestion how can I achive this.

Thanks all

You can automate this using DTS (Data Transformation Services) from Microsoft. Check the DTS section in Online Books of Microsoft SQL Server for detailed information on this.

Thanks aleman,.. I got it…
this is cool I can just dump all the files in a directory and schedule the DTS import/export wizard to run at a particular time… thats it, right…

cool… thanks…