By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,183 Members | 1,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,183 IT Pros & Developers. It's quick & easy.

Import data from excel to dataset

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.