Importing ADO Persisted XML into Excel 2002

  • Thread starter Thread starter gadrin7
  • Start date Start date
G

gadrin7

Is it possible to take a ADO.Recordset, which is persisted to XML and
import that into Excel 2002 ?


I'm using VB/VBA/VBS.


I can find a range on a worksheet, and export it to MSPersist format
pretty easy, so I assume the reverse can be done ?
If so, does anyone have any sample code ?
 
Is it possible to take a ADO.Recordset, which is persisted to XML and
import that into Excel 2002 ?
Click to expand...

You should be able to just open it in Excel, it should render it
somehow. You could re-open the recordset using ADO in VBA code then use
Excel's CopyFromRecordset method to copy the data to a worksheet. These
seem very obvious so perhaps you are looking to do something more
subtle...?

Jamie.

--
 
Back
Top