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

exporting data in excel to C# dataset

P: n/a
How do you go about exporting data in excel to a C# dataset?

Any help would be really appreciated.
Cheers,

Mike
*** Sent via Developersdex http://www.developersdex.com ***
Nov 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Mike,

The easiest way would be to use an OleDbDataAdapter and use the Jet
provider for OLEDB, as it can read Excel workbooks.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Mike P" <mi*******@gmail.com> wrote in message
news:OM*************@tk2msftngp13.phx.gbl...
How do you go about exporting data in excel to a C# dataset?

Any help would be really appreciated.
Cheers,

Mike
*** Sent via Developersdex http://www.developersdex.com ***

Nov 17 '05 #2

P: n/a
Jan
Hi Mike,
You have few options:
a) Use excel automation (excel object) to read data from XLS file and
fill the dataset.
b) Use some third-party component, like ExcelLite (free if you need
less than 150 rows).
For comparison, see:
http://www.gemboxsoftware.com/ExcelLite.htm#Automation
Regards,
Jan

Mike P wrote:
How do you go about exporting data in excel to a C# dataset?

Any help would be really appreciated.
Cheers,

Mike
*** Sent via Developersdex http://www.developersdex.com ***


Nov 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.