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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cut & Paste in Excel without erasing cell borders? 1
Excel Unable to insert cut rows into Excel online anymore? 0
Excel - cut and paste 3
Cut and paste problems! 2
Cut and Paste 2
Find Cut and paste 4
Cut and Paste 4
Cut and paste objects into userforms 8

Back
Top