ADO.NET and Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rguarnieri - 25 Apr 2006 18:33 GMT

Hi!!, I need to populate an excel sheet with a query, some people says
that I can use CopyFromRecordset to do that but I need to add a
reference to an ADODB.Recordset, my question is, le ADODB library is
included in framework 2.0?, Do I have to make an extra instalation of
this library for the end users?

Thank you.
Ruben.

Reply to this Message

Robbe Morris [C# MVP] - 25 Apr 2006 22:24 GMT

ADODB is COM and not .NET. It is apart of MDAC.
I'm not sure what the current version is. At least 2.8.
You can get this from microsoft downloads.

You can then add a COM reference to your .net project
in order to use it via COM Interop.

Signature

Robbe Morris - 2004-2006 Microsoft MVP C#
Earn money answering .NET questions
http://www.eggheadcafe.com/forums/merit.asp

> Hi!!, I need to populate an excel sheet with a query, some people says
> that I can use CopyFromRecordset to do that but I need to add a
[quoted text clipped - 4 lines]
> Thank you.
> Ruben.

Reply to this Message

Paul Clement - 27 Apr 2006 13:13 GMT

¤ Hi!!, I need to populate an excel sheet with a query, some people says
¤ that I can use CopyFromRecordset to do that but I need to add a
¤ reference to an ADODB.Recordset, my question is, le ADODB library is
¤ included in framework 2.0?, Do I have to make an extra instalation of
¤ this library for the end users?

See the below KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;316934

Paul
~~~~
Microsoft MVP (Visual Basic)

Reply to this Message

ADO.NET and Excel

Free Magazines