To transfer your data without Automation, you can use the following approaches:

If you are running a server-side program, this can be a good approach for taking the bulk of data processing away from your clients. You can also use several methods that do not necessarily require Automation to transfer data to Excel. Transfer data to the clipboard, and then paste the clipboard contents into an Excel worksheet.Create a QueryTable object on an Excel worksheet that contains the result of a query on an ODBC or OLEDB data source.Transfer data in an ADO recordset to a range of cells by using the CopyFromRecordset method.Transfer data in an array to a range of cells.With Automation, you can use several techniques to transfer your data: Automation gives you the greatest flexibility for specifying the location of your data in the workbook, formatting the workbook, and making various settings at run-time. With Automation, you can call methods and properties that are specific to Excel tasks. The technique that is most frequently used to transfer data to an Excel workbook is Automation.

This article also presents the advantages and disadvantages of each method so that you can select the solution that works best for your situation.

This step-by-step article describes several methods for transferring data to Microsoft Excel 2002 from a Microsoft Visual C# 2005 or Microsoft Visual C#. For a Microsoft Visual Basic 6.0 version of this article, see 247412.

How to use microsoft excel workbook