Better, Faster Exporting to Excel

[btidwell3]

To All,



I have an application that exports large amounts of data, to pre-formatted, Excel worksheets. Using the, "TransferSpreadsheet" method built into Access is too slow.

Is anyone aware of a third-party tool that could help with this problem?

Sincerely,

WDT3

[CJ_London]

I doubt there is a third party tool that will be faster. Usual suspect is the data to be transferred is a slow query.

Have you tried using docmd.outputto? https://msdn.microsoft.com/en-us/vba...-method-access

or creating an excel object? https://www.devhut.net/2012/04/19/ms...ords-to-excel/

[btidwell3]

Ajax,

Thanks. I will take a look at this.

WDT3

[ssanfu]

Another site for working with Excel workbooks is by Ken Snell:
Ken's ACCESS Examples and Information for Working With EXCEL Workbook Files