OWC Spreadsheet and persisted ADO recordset

[MrNDIS]

It seems that both charting and pivot table components can read in XML
generated from ADO persisted record set using the following syntax

ChartSpace1.ConnectionString = "Provider=MSPersist.1"
ChartSpace1.CommandText = "URL providing persisted data"


Is it possible to do the same with SpreadSheet component, all my
experiments are failing so far. Any insights? The goal is to read an
persisted recordset and put it in a worksheet.


Thanks

 

[Alvin Bruney [MVP]]

What errors are you having, the worksheet will bind directly to the
recordset because the recordset implements idatasource.

 

[MrNDIS]

What errors are you having, the worksheet will bind directly to the
recordset because the recordset implements idatasource.

Can you show an example of binding spreadsheet to a recordset and can
it bind to XML persisted recordset?

 

[Alvin Bruney [MVP]]

Something like this should work > I don't have a recordset handy so this
code may not work smoothely.

SpreadSheet1.Cells.CopyFromRecordset recordset

a full example is here
http://excelkb.com/article.aspx?id=10190