From excel file into MS SQL server

[no one]

I need to find a way to upload an Excel file into an MS SQL database
using a web control front end. I have my ASP.Net control (using C#)
uploading a file to a directory, but the server people now tell me that
I cannot have a writeable area for the web and have a DTS see it as this
is too much of a security risk. So, I need a way to read the file
directly into the database. I've no idea how to do this. Does anyone
have ideas? I know loading MS Office into the web server is out of the
question. The webserver and database server are not the same physical
machine.

Thanks.

 

[Steve C. Orr [MVP, MCSD]]

Yes you can upload any file directly into SQL Server.
Here's an example:
http://SteveOrr.net/Articles/EasyUploads.aspx

 

[no one]

Thanks for the link, but this is not what I want to do. I want to put the
data from the file into a table, not the file itself.

 

[Steve C. Orr [MVP, MCSD]]

Oh, I now see your dilemma. That's fairly complex functionality.
My only idea is this 3rd party product that can open an excel file from a
memory stream and will allow you to extract data from it:
http://www.SteveOrr.net/Reviews/AsposeWord.aspx
http://www.aspose.com/Products/Aspose.Excel/

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net