Hello all,

Is there a way to simulate the CopyFromRecordSet method (it accepts DAO or
ADO recordset objects) from the office.excel.dll,  so it can work with
datasets/datatables?

Thank you in Advance
E-cube

On Mon, 28 Mar 2005 08:51:09 -0800, E-Cube <EC***@discussions.microsoft.com> wrote:

¤ Hello all,
¤
¤ Is there a way to simulate the CopyFromRecordSet method (it accepts DAO or
¤ ADO recordset objects) from the office.excel.dll,  so it can work with
¤ datasets/datatables?
¤

There is no equivalent. The workaround is a little ugly and involves converting a Dataset to an ADO
Recordset using XML, before using it in CopyFromRecordset.:

How To Convert an ADO.NET DataSet to ADO Recordset in Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;316337


Paul
~~~~
Microsoft MVP (Visual Basic)

FindWindow API
FileSystemObject vs System.IO.File
compression of a string , but must be interoptable someone an idea ??
Array of Hash Tables
Query database in VB.NET
Problems with the PrintPreviewControl, PrintPreviewDialog controls
VB to C#
the project location is not fully trusted by .net runtime
[String]
Create ListView columns dynamically from XML