Export to MS Excel
I bought this book 1 week ago. It's fascinating, it's great, it's amazing ... Just "WOW". Really!
While reading the book, the following question came up:
Why didn't you write anything 'bout DoCmd.TransferSpreadsheet? It's much faster than the method described in your book (chapter 10, page 421ff.).
A specific example: a client of us needs to export a recordset of about 20,000 records(!). If I implement the method in "your" way it takes more than 3 minutes to complete the export.
If I use
SELECT * INTO [tmpTable] FROM [QUERY]
to create a temporary Access table and
DoCmd.TransferSpreadsheet acExport, , tmpTable, exportFileName, True
to export the data it's much faster: about 2 seconds!
I know: if using DoCmd.OutputTo you are limited to 65,000 records. There seems to be no limitation if using DoCmd.TransferSpreadsheet.
Thanks a lot in advance for answering and best regards from Germany!
Last edited by egan0815; August 16th, 2013 at 01:31 PM.