469,898 Members | 1,779 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

import Excel-sheet in SQL server through asp.net webpage

What would be the best and easiest way to implement a web page that allows
me to:

- import an Ms Excel-sheet in a database on a Ms Sql 2000 Server
- this should be done through an asp.net webpage
- I should be able to update or add records

thx 4 advice

Nic
Nov 19 '05 #1
3 2217
Heres an idea:

Set up a folder that both the web app and SQL server can get to.
Do a simple file upload from the web app
Set up a DTS package to periodically check the folder to do an import
-or-
Set up a DTS package that will do the import and call it from a Stored
Proc after the web app does the upload
Clint Hill
H3O Software
http://www.h3osoftware.com
nicholas wrote:
What would be the best and easiest way to implement a web page that allows
me to:

- import an Ms Excel-sheet in a database on a Ms Sql 2000 Server
- this should be done through an asp.net webpage
- I should be able to update or add records

thx 4 advice

Nic

Nov 19 '05 #2
You can use Excel as an ADO.NET data source:
http://www.dotnetspider.com/technolo...ages/1080.aspx

Here are some other articles that may help as well:
http://SteveOrr.net/articles/ExcelExport.aspx
http://SteveOrr.net/articles/ExportPanel.aspx
http://SteveOrr.net/articles/EasyUploads.aspx

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

"nicholas" <mu********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
What would be the best and easiest way to implement a web page that allows
me to:

- import an Ms Excel-sheet in a database on a Ms Sql 2000 Server
- this should be done through an asp.net webpage
- I should be able to update or add records

thx 4 advice

Nic

Nov 19 '05 #3
Thanks a lot, both of you, for help !
Nic

"nicholas" <mu********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
What would be the best and easiest way to implement a web page that allows
me to:

- import an Ms Excel-sheet in a database on a Ms Sql 2000 Server
- this should be done through an asp.net webpage
- I should be able to update or add records

thx 4 advice

Nic

Nov 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Johnny Meredith | last post: by
1 post views Thread by John Hewitt | last post: by
10 posts views Thread by Niklas | last post: by
3 posts views Thread by Roy | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.