File UPload to DATABASE

Classic Servoy
1

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

2

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.

3

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…