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 <(E-Mail Removed)> 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...b;en-us;316337


Paul
~~~~
Microsoft MVP (Visual Basic)