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!

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. 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.

How To Import MS Excel Data INTO MS Access 2016 Database