insert excel on access form

B

balu

dears
how to insert an excel worksheet on access form and get the excel
functionalitys
 
F

fredg

dears
how to insert an excel worksheet on access form and get the excel
functionalitys
Click to expand...

The Worksheet already exists?
Open the form in Design View.
Click on Insert + Object + Microsoft Excel Worksheet.
Click on Create From File. Navigate to the spreadsheet.
Click OK.
Place a check in the Link check box.
Click OK

After the worksheet is added to the form, make sure the OLEUnbound
Control's Locked property is set to No and it's Enabled property is
set to Yes.

Only the first sheet will be displayed.
Double-click on the worksheet to edit it.
When you're in edit mode you can access all the worksheets.
 
K

Klatuu

fredg's answer will get you where you want to go; however, in my experience,
using an OLE bound control to present an excel sheet on an Access form is
very slow. It is slow to load and slow to save.

If you have the same issue, you may consider just using the Shell statement
to open Excel with the spreadsheet.
 
Top