COM/OLE Automation - Excel

[links]

Access 2003 can export a table to Excel (newer versions can probably do the same).

How do they do it? Do they use COM Automation?

[VictorN]

I don't believe they use Automation to export data. I guess it would be much faster when using ISAM drivers for MS Excel.
The same way they export data into text file (using ISAM drivers for text files)

[links]

Thanks for your reply. First time I've heard of ISAM! Sounds like something I need so I can create formatted XLS files.

Is there documentation available for this ISAM driver for Excel?

[VictorN]

It is not so complicated. You just need to properly set the connection string for Excel sheet where you will export your data.
Accessing Data with ADO
Connection strings for Excel 2007
Connection strings for Excel