473,856 Members | 1,481 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Import data from excel to dataset

I would like to know if it is possible to import data from MS Excel
2000 to a dataset using asp.net. The excel file would need to be
uploaded to the server from a web page first, before the loaded into a
dataset. After the data is stored in the dataset, i would need to write
the information to an access db. If it is possible to do this, where
can I find help on how to import excel data to a dataset?

Thanks!

Nov 19 '05 #1
3 2714
These articles should provide all the answers you need:

Uploading files (optionally into a database)
http://SteveOrr.net/articles/EasyUploads.aspx

Export to Excel
http://SteveOrr.net/articles/ExcelExport.aspx

Import from Excel
http://www.dotnetspider.com/technolo...ages/1080.aspx

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

"Schultz" <sc***********@ gmail.com> wrote in message
news:11******** *************@g 14g2000cwa.goog legroups.com...
I would like to know if it is possible to import data from MS Excel
2000 to a dataset using asp.net. The excel file would need to be
uploaded to the server from a web page first, before the loaded into a
dataset. After the data is stored in the dataset, i would need to write
the information to an access db. If it is possible to do this, where
can I find help on how to import excel data to a dataset?

Thanks!

Nov 19 '05 #2
On 6 May 2005 09:23:01 -0700, "Schultz" <sc***********@ gmail.com> wrote:

¤ I would like to know if it is possible to import data from MS Excel
¤ 2000 to a dataset using asp.net. The excel file would need to be
¤ uploaded to the server from a web page first, before the loaded into a
¤ dataset. After the data is stored in the dataset, i would need to write
¤ the information to an access db. If it is possible to do this, where
¤ can I find help on how to import excel data to a dataset?

Assuming you're uploading the Excel Workbook to the file system you can actually import directly
into an Access database, w/o having to use a DataSet.

You may want to follow-up with some more details if you need additional help.
Paul
~~~~
Microsoft MVP (Visual Basic)
Nov 19 '05 #3
Reading an Excel file into a DataSet is definitely possible as I have done
this in the past. The articles mentioned by other responders will help you
out. One thing that drove me crazy when I was developing similar
functionality was an OleDBException error I got when trying to read the file
that was uploaded. I'd link you to the page that fixed it for me, but it is
no longer available. However, it was permissions problem. When the ASP.NET
account was reading the Excel file, it was attempting to create a temp file
at C:\Documents and Settings\<machi ne_name>\ASPNET \Local Settings\Temp. For
some reason the ASP.NET account did not have write access to this directory.
Once I gave it the permissions it needed, no more error. Hope this helps.

"Schultz" wrote:
I would like to know if it is possible to import data from MS Excel
2000 to a dataset using asp.net. The excel file would need to be
uploaded to the server from a web page first, before the loaded into a
dataset. After the data is stored in the dataset, i would need to write
the information to an access db. If it is possible to do this, where
can I find help on how to import excel data to a dataset?

Thanks!

Nov 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
8016
by: Chris | last post by:
Could someone please provide me an effective means of exporting data from a data set (or data grid) to Excel?
1
1819
by: Jonathan Woods | last post by:
Hi there, how do u handle export/import data between your App and other data sources(e.g. excel spreedsheet). use DTS package? How do u do that?
7
5088
by: postings | last post by:
Hi - can you help please? Please review the following straightforward code which works fine with ordinary XML files. ---------------------------------------------------------------- Dim originalxmlsource As New DataSet Dim xmlfilename As String = Request.PhysicalApplicationPath _ & "myfilename.xml" MyDataGrid.DataSource = originalxmlsource
0
1671
by: ramnaresh_t yadav via .NET 247 | last post by:
Hi, I am pasting the code to import data from Text/Excel files into Database(Oracle ) Table... I think some one needs this .. they can use.. it... ======================= Dim dsDB As New DataSet Dim daDB As New OracleDataAdapter Dim cmdDB As OracleCommand = New OracleCommand Dim strRow As String Dim sqlArr() As String 'Array which stores all queries of all records to be executed as a whole to database Dim RetVal As Long = 0
10
11840
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 .NET. The data in Excel is not in structured columns but can exist everywhere in the workbook. For example if I am supposed to import a person and all his/her cars which exist in a workbook I want to be able to create an import protocol and specify...
4
2290
by: jayfeb29 | last post by:
Hi , Any one can guide me in Import the Excel 2002 data into sql server 2000 using ado.net1.1. I have searched all the forums most of the solutions end with a line of suggestion not with any code . here is my code . by using OLEDB JET I got the data from Excel to data set , the data is in the data table OleDbConnection strConn = new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;data source= c:\\1005.xls;Extended...
7
12085
by: TG | last post by:
hi! I am trying to create a sql server table from an excel sheet. Here is the code I have: 'This procedure the xlsx file and dumps it to a table in SQL Server
1
7123
by: orked | last post by:
i tried to import excel file into gridview but the code made this exception (Failed to map this path''xmlTest.xml") i don't know why my code: public void fillGrid() { DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath("../xmlTest.xml")); GridView1.DataSource = ds; GridView1.DataBind(); } protected void Page_Load(object sender, EventArgs e)
4
2830
by: orked | last post by:
i want to import excel file to gridview but there was error(Failed to map this path "/xmltest.xml") and i couldn't handle it my code: public void fillGrid() { DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath("../xmltest.xml")); GridView1.DataSource = ds; GridView1.DataBind(); } protected void Page_Load(object sender, EventArgs e) {
0
11065
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10700
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10797
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10391
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7098
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5763
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5962
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4583
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4177
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.