Accessing excel files from C#

[Mike Grishaber]

Does anyone know how to read an Excel file using C# and treat the resluts as
RecordSets?

Thanks

Mike

[Nicholas Paldino [.NET/C# MVP]]

Mike,

Do you mean ADODB recordsets, or a data set? If you mean ADODB
recordsets, then you can use COM interop and use the JET OLE DB Provider to
get a recordset in C#.

If you mean a DataSet, then you will have to use COM automation to
access Excel, and get the information programatically to populate the
DataSet.

The Knowledge base article 316126, titled "HOW TO: Use Visual C# .NET to
Automate a Running Instance of an Office Program" should help, it is located
at (watch for line wrap):

http://support.microsoft.com/default...b;en-us;316126

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

"Mike Grishaber" <mg********@cp.org> wrote in message
news:oP*********************@news20.bellglobal.com ...

Does anyone know how to read an Excel file using C# and treat the resluts
as
RecordSets?

Thanks

Mike

[Shiva]

Hi,
If you meant using ADO.NET (no RecordSets), then check this one:
http://support.microsoft.com/kb/306572

For ADO (with RecordSets), see if this helps:
http://support.microsoft.com/kb/306023

"Mike Grishaber" <mg********@cp.org> wrote in message
news:oP*********************@news20.bellglobal.com ...
Does anyone know how to read an Excel file using C# and treat the resluts as
RecordSets?

Thanks

Mike