File UPload to DATABASE

[arumalla]

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

[Jan Aleman]

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.

[arumalla]

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...