Cutting and pasting Excel spreadsheet into asp.net

  • Thread starter Thread starter Roz Lee
  • Start date Start date
R

Roz Lee

I want to cut and paste an Excel spreadsheet into a web page and then
update my SQLServer database - it's basically an import function but
using cut and paste rather than reading the file from a directory.
So far I have managed to open a new page as a blank worksheet and cut
and paste an existing spreadsheet into it. Now can I access it
programmatically to write the cells into my database?
Any help, useful articles etc much appreciated.
Ros Lee
Panztel Ltd
 
Ros Lee,

Here is just suggestion.

You can cut and past the required data in new Excel.
Upload that new excel to SQL DTS which put Excel into SQL
server.
Please look into this.. You will lot of articles on
calling DTS through ASP.NET. and creating DTS component is
very easy.

All the best.
Sridhar
 
Back
Top