Exporting data to Excel 4

[cjac]

Hi, does anyone know if it possible to export the contents of a recordset to Excel, ie. without binding the recordset to a datagrid or flexi grid and then exporting the contents from the datagrid/flexigrid? I'm not sure if this is possible but if it is it would certainly cut down on code. If this is not possible I guess I will have to open a hidden flexi grid, export the contents of the recorset into the grid and then export from the grid to Excel. Any ideas...?

Cheers!

 

[VBrit]

Ok, 65536, my mistake!

If the recordset was larger than that then the ADO code wont work.