ADO.NET and Excel

25 Apr 2006 5:33 PM

rguarnieri

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.

25 Apr 2006 9:24 PM

Robbe Morris [C# MVP]

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.

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

Show quote

"rguarnieri" <ru***@hmstrategies.com> wrote in message
news:1145986431.069450.190800@j33g2000cwa.googlegroups.com...
> 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.
>

27 Apr 2006 12:13 PM

Paul Clement

On 25 Apr 2006 10:33:51 -0700, "rguarnieri" <ru***@hmstrategies.com> wrote:

¤ 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)