R
Rich Ulichny
Not sure if this is correct newsgroup but I figured I had to start
somewhere.
We need to build a Web based application to allow users to choose an Excel
file from their hard drive (or other mapped drive). At that point the
following needs to happen:
Upload the Excel File to the Webserver(or other server) and extract certain
data elements from the many tabs in the sheet. The extracted data needs to
be inserted into various SQL Server tables for reporting/query capabilities.
The good news is the worbook is protected so the data can always be found in
the same cells. However, the data is
scattered across various tabs in the workbook.
Some Assumptions based on existing infrastructure are:
SQL Server will be database
..NET will be used for Web Application
Any recommendations for how this can best be accomplished?
One sample application we have uses an ActiveX control that is called via
ASP/.NET page. This app basically opens the workbook and grabs data from
various cells. My thinking was this
could be used as a starting point to grab data, pass it to SQL Server stored
procs whichwould perform inserts into necessary tables.
I am new to .NET/Web programming so I'm looking for any possible pitfalls.
My research into the sample application above brought up some security
issues with installing and using ActiveX applications but I don't have
enough experience to know if that's a show stopper.
Any advice would be appreciated. Thanks,
Rich
somewhere.
We need to build a Web based application to allow users to choose an Excel
file from their hard drive (or other mapped drive). At that point the
following needs to happen:
Upload the Excel File to the Webserver(or other server) and extract certain
data elements from the many tabs in the sheet. The extracted data needs to
be inserted into various SQL Server tables for reporting/query capabilities.
The good news is the worbook is protected so the data can always be found in
the same cells. However, the data is
scattered across various tabs in the workbook.
Some Assumptions based on existing infrastructure are:
SQL Server will be database
..NET will be used for Web Application
Any recommendations for how this can best be accomplished?
One sample application we have uses an ActiveX control that is called via
ASP/.NET page. This app basically opens the workbook and grabs data from
various cells. My thinking was this
could be used as a starting point to grab data, pass it to SQL Server stored
procs whichwould perform inserts into necessary tables.
I am new to .NET/Web programming so I'm looking for any possible pitfalls.
My research into the sample application above brought up some security
issues with installing and using ActiveX applications but I don't have
enough experience to know if that's a show stopper.
Any advice would be appreciated. Thanks,
Rich