Exporting a table to Excel

[JoseSharp]

Hi all, I use a d'base that exports a table via a query to Excel. Once the user hits the button to run this command it can take between 30 sec to 60 sec until the data is displayed in excel.

Does anyone know of anyway to speed this process up. Currently there are around 12,000 records with the table.

DoCmd.OutputTo acOutputQuery, "qryArchiveReport", acFormatXLS, "Archive.xls", True

thanks for looking

 

[gemma-the-husky]

try docmd.transferspreadsheet - that might be quicker


12000 records in 30-60 secs isnt too bad though is it.