ADO.NET and Excel

  • Thread starter Thread starter rguarnieri
  • Start date Start date
R

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.
 
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.
 
¤ 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)
 
Back
Top