[AccessD] Exporting from an Access 2007 Query to Excel - DoCmd.OutputTo Versus DoCmd.TransferSpreadsheet

Brad Marks BradM at blackforestltd.com
Sat Jul 23 13:58:25 CDT 2011


All,

I am curious if there are significant differences between using
"DoCmd.OutputTo"  Versus  "DoCmd.TransferSpreadsheet" when exporting an
Access 2007 Query to Excel.

As I understand it, TransferSpreadsheet can handle more rows, but I was
wondering if there are any other differences that should be kept in mind
when choosing between these two approaches.

Thanks,

Brad




More information about the AccessD mailing list