469,282 Members | 1,604 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

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 2324
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*********************@g14g2000cwa.googlegro ups.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\<machine_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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Chris | last post: by
1 post views Thread by Jonathan Woods | last post: by
7 posts views Thread by postings | last post: by
reply views Thread by ramnaresh_t yadav via .NET 247 | last post: by
10 posts views Thread by Niklas | last post: by
1 post views Thread by orked | last post: by
4 posts views Thread by orked | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.