Hi,
I am trying to export the result of an access query to excel. I have read somewhere that the TransferSpreadsheet method is faster, but it seems that the filesize of the resulting workbook is smaller when I use OutputTo. However, I have no clue what is the difference between these two methods. Would appreciate if someone could enlighten me on this. Also, which would be better for exporting a query resultset of around 40,000 records to excel?
Thanks in advance.
Regards,
Russ
I am trying to export the result of an access query to excel. I have read somewhere that the TransferSpreadsheet method is faster, but it seems that the filesize of the resulting workbook is smaller when I use OutputTo. However, I have no clue what is the difference between these two methods. Would appreciate if someone could enlighten me on this. Also, which would be better for exporting a query resultset of around 40,000 records to excel?
Thanks in advance.
Regards,
Russ