Reading/Writing Excel Spreadsheets with ADO.NET

David Hayden maintains a really great blog.  He regularly posts about ADO.NET and Data Access, and is someone I'd highly recommend subscribing to.

He posted a useful blog entry a few days ago that details how to use ADO.NET to read, insert and update data from an Excel spreadsheet.  A useful read if you are looking to quickly export or import data and work with it interatively in Excel.

Hope this helps,

Scott

 

Published Monday, May 29, 2006 11:21 AM by ScottGu
Filed under: , ,

Comments

# re: Reading/Writing Excel Spreadsheets with ADO.NET

Monday, May 29, 2006 5:16 PM by Rhonda Tipton
I agree completely.  I am very new to the .NET world and I get the most useful information from David Hayden's blog as well as your blog.  Thanks!

# re: Reading/Writing Excel Spreadsheets with ADO.NET

Monday, May 29, 2006 8:16 PM by Sahil Malik
Having written a fairly successful book on ADO.NET 2.0, I'd like to second that - David Hayden's blog is awesome!!

# re: Reading/Writing Excel Spreadsheets with ADO.NET

Tuesday, May 30, 2006 1:30 AM by Mohamed Rashed
that's realy greate and simple ...
i face a peoblem in how to read from excel and insert the data in the db, have any idea ...
i tried use sqlbulkcopy but it faild because of the datatypes !!!

# Quick Links 200605301103

Tuesday, May 30, 2006 6:28 AM by Tiernans Comms Closet
Here are some quick links for today:
Mini-Microsoft quits! (but not fully)
Custom MSBuild task for...

# re: Reading/Writing Excel Spreadsheets with ADO.NET

Tuesday, May 30, 2006 2:47 PM by Srini
Is there any blog on reading/writing into Excel Spreadsheet using .NET 1.1?

# re: Reading/Writing Excel Spreadsheets with ADO.NET

Thursday, June 01, 2006 10:51 AM by Brandon Tyler
I have the same problem.  MSS 2004 R2 Speech SDK only works with VS 2003 and I was wanting some good information there on writing to Excel Spreadsheets.

# re: Reading/Writing Excel Spreadsheets with ADO.NET

Sunday, June 11, 2006 11:11 AM by Seinti
Thanks.

# re: Reading/Writing Excel Spreadsheets with ADO.NET

Monday, July 17, 2006 4:14 AM by MichealLee
For excel export functionality , There is .net component called Spire.DataExport, I have heard that it is quite good for generating Excel files. Not needing have MS Excel installed on machine, free download. see: http://www.e-iceblue.com

# re: Reading/Writing Excel Spreadsheets with ADO.NET

Tuesday, August 08, 2006 1:26 AM by Malik Shehryar Gul
hello every one plz send me the sample code for reading and writing Excel files

# re: Reading/Writing Excel Spreadsheets with VS.NET

Wednesday, August 09, 2006 6:37 AM by Arun
Need input - > how to read excel report using vs.net