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

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"no one" <no***@yahoo.com> wrote in message
news:41***************@yahoo.com...

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.

[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]" wrote:

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

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

"no one" <no***@yahoo.com> wrote in message
news:41***************@yahoo.com...

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.

[Simon Hayes]

"no one" <no***@yahoo.com> wrote in message
news:41***************@yahoo.com...

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]" wrote:

<snip>

Have a look at DTS - it can load directly from Excel (or most other things)
to MSSQL, and you can change the source and destination connections at
runtime. This link discusses executing a package from ASP:

http://www.sqldts.com/default.aspx?207

Otherwise, you can parse the file and generate your own INSERT statements
(slow), or convert it to a flat text file and then use bcp.exe or BULK
INSERT to load the data.

Simon

[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
"no one" <no***@yahoo.com> wrote in message
news:41***************@yahoo.com...

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]" wrote:

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

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

"no one" <no***@yahoo.com> wrote in message
news:41***************@yahoo.com...

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

[Tzvika Barenholz]

DTS has been mentioned.
3rd parties that also do the job: SQLWays , DBUnit.

[Andy O'Neill]

"no one" <no***@yahoo.com> wrote in message
news:41***************@yahoo.com...

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.

Did you know cross-posting is one of the things some ISPs pick to identify
spam?
This'd be a whole lot easier if your app was windows rather than web.
Coz you don't have any way to be running c# on our client machine.

Is this really an extranet app?
I'd be concerned about who's loading what out a spreadsheet onto my database
server.
It does sound like a good way to open up a hole for hackers to walk in
through.
Uploading excel spreadsheets is also a good way to get a big heap of bad
data into a system.

Anyhow, it piqued my interest so I did a search on "javascript excel"
Here's an interesting page I found.
http://www.planet-source-code.com/vb...=2180&lngWId=2

Some gotchas but maybe they're not a problem for you.

--
Regards,
Andy O'Neill