ADO presents you with a more scaleable solution to handle data in a workbook.ĪDO can be used strictly to transfer raw data to a workbook. For Web applications, it is not always desirable to automate Microsoft Excel. ADO runs in-process, and saves the overhead of costly out-of-process calls.
Microsoft Excel is an out-of-process ActiveX server. The use of ADO to transfer data to or retrieve data from an Excel workbook gives you, the developer, several advantages over Automation to Excel: The ExcelADO.exe sample illustrates how you can use ActiveX Data Objects (ADO) with the Microsoft Jet OLE DB 4.0 Provider to read and write data in Microsoft Excel workbooks.
ExcelADO demonstrates how to use ADO to read and write data in Excel workbooks Summary
