Faster data export from access to excel

[meboz]

Hi,

Im exporting data from access to excel using access as the server.

I was wondering what type of things can be done to speed up this process.

I am getting a recordset then looping through and making the cell values of the spreadsheet equal to values from my recordset fields.

Thanks

 

[RoyVidar]

You could try the copyfromrecordset method of the Excel Range object. Works with both DAO and ADO recordsets, if you can't use the good old transferspreadsheet thingie.