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