473,320 Members | 2,117 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 2411
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Fred | last post by:
Hi. How do I import while mapping an excel table to an access table please??? I've searched around and all I can find is a software product or code that does the same thing as the access...
2
by: Fred | last post by:
Hi. How do I import while mapping an excel table to an access table please??? I've searched around and all I can find is a software product or code that does the same thing as the access...
5
by: Johnny Meredith | last post by:
I have seven huge fixed width text file that I need to import to Access. They contain headers, subtotals, etc. that are not needed. There is also some corrupt data that we know about and can...
1
by: John Hewitt | last post by:
A 'newbie' question - importing into Access from Excel. Googled the group postings but I can't find the amswer I have a 50 line three column file in Excel that contains Names and Tel numbers....
3
by: deko | last post by:
I've been trying to use the Access Import Wizard to expedite importing data into my mdb. The nice thing about the wizard is that I can import from different file formats - txt, xls, even Outlook -...
0
by: autoEx | last post by:
I am using #import directive to import the excel library to make excel files but the excel object is not recognized by my application. Here is what I do: I have simple dialog based MFC application in...
10
by: Niklas | last post by:
Hi Before I start coding I need to be sure that nobody else has not done it yet and that I can use it. I need an import utility which import data from Excel to a database or some object in...
3
by: Simon | last post by:
Dear reader, One table in database A...mdb is linked to a table in database B..mdb. As A..mdb is open and in B...mdb starts an excel import procedure the progress bar shows that the import...
3
by: Roy | last post by:
Hi All, I have an A2003 application .Recently we had a request to import data from IDL files and create some reports. Since I have no idea to do that using Access,I used Excel to import data and...
8
by: shenkel55 | last post by:
I'm using Access and Excel 2003. Using either the import wizard or code, I have the same problem. This problem only happens with Excel files automatically generated by Corp IT. If I try to do an...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.