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

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


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!

edwards142 December 4th, 2017 12:38 AM

Well dear I donít have much knowledge regarding exporting to excel but few days back I have tried how to Import Excel Data Into Access.[:confused:] But if you want to require knowledge regarding that then I think I can help you out. So here are the complete steps mentioned how to perform this task.[:o]

How To Import MS Excel Data INTO MS Access 2016 Database


All times are GMT -4. The time now is 12:32 PM.

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