p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Expert Access 2007 Programming ISBN 978-0-470-17402-9 (http://p2p.wrox.com/book-expert-access-2007-programming-isbn-978-0-470-17402-9-371/)
-   -   Export to MS Excel (http://p2p.wrox.com/book-expert-access-2007-programming-isbn-978-0-470-17402-9/90702-export-ms-excel.html)

egan0815 August 16th, 2013 10:26 AM

Export to MS Excel
 
Hello,

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!


All times are GMT -4. The time now is 09:24 AM.

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.