Access Database Development Ireland

See Also > Opening a WorkBook > Adding a New WorkSheet > Selecting a Specific Location

Notes on Automating Excel

The approach most commonly used to transfer data to an Excel workbook is Automation. Automation gives you the greatest flexibility for specifying the location of your data in the workbook as well as the ability to format the workbook and make various settings at run time. With Automation, you can use several approaches for transferring your data:

Transfer data cell by cell
Transfer data in an array to a range of cells
Transfer data in an ADO recordset to a range of cells using the CopyFromRecordset method
Create a QueryTable on an Excel worksheet that contains the result of a query on an ODBC or OLEDB data source
Transfer data to the clipboard and then paste the clipboard contents into an Excel worksheet

There are also methods that you can use to transfer data to Excel that do not necessarily require Automation. If you are running an application server-side, this can be a good approach for taking the bulk of processing the data away from your clients. The following methods can be used to transfer your data without Automation:
Transfer your data to a tab- or comma-delimited text file that Excel can later parse into cells on a worksheet
Transfer your data to a worksheet using ADO