What are the relative merits of OutputTo and TransferSpreadsheet?
Posted on 2011-09-14
I am developing an Access front-end on a SQL Server database and need to get data out into Excel.
I am finding OutputTo very slow to produce the 11 thousand records. But it gets there in the end.
TransferSpreadsheet is much faster (Why?) but seems to be less reliable. It seems to be that if the destination spreadsheet has anything in it that the export doesn't expect, it crashes. Also, you have to have extra code to open the spreadsheet afterwards.
Up to now I've been using OutputTo, but am wondering whether TransferSpreadsheet would be better if we can prevent the crashes. But, how to prevent the crashes?
I'm interested in what I should know about the two methods and if one is preferable to the other.