There are several types of Excel objects that you can insert into your form or report. Two of the most common are worksheets and charts. You can insert a new Excel worksheet and then add data to it, or you can insert an existing Excel worksheet. You can also insert a chart from an Excel workbook.
Insert an Excel Chart
 |
In Excel, click the chart you want to insert in the Access report or form.
|
 |
In Excel, click the Copy button on the Standard toolbar.
|
 |
Switch to Access, and, in Design view, display the form or report on which you want the chart.
|
 |
Click the Paste button.
|
 |
Click outside the chart to deselect it.
|
|
You can drag and drop to Excel. You can drag objects from Excel right into Design view. Make sure that neither window is maximized and that both the object you want to drag and its destination are visible.
You can edit an inserted Excel worksheet. If you want to modify the worksheet, double-click it, and then use the Excel tools to edit. When you're done, click the Close button, and then click Yes to save changes.
|
Insert an Excel Worksheet
|
Display the form or report into which you want to insert the Excel worksheet.
|
|
Click the Insert menu, and then click Object.
|
|
Click the Create From File option.
|
|
Click Browse, locate and select the worksheet, and then click OK.
|
|
Click OK.
|
 |
