Attaching an Excel file ina Form

[Guest]

Is there a way to "attach" an external Excel file in an Access DB Form?

 

[fredg]

Is there a way to "attach" an external Excel file in an Access DB Form?

I don't know what you mean by 'attach' but you can use an OLEUnbound
control to display the spreadsheet file. Using the wizard, navigate
and link to the spreadsheet file.
Set the control's Enabled property to Yes, and it's Locked property to
No.
Double-click on the control to edit the spreadsheet (if that is what
you want).

 

[Guest]

FredG,

Please expand - what wizard would I use and how do I access the wizard you
are talking about. Thanks.

 

[fredg]

FredG,

Please expand - what wizard would I use and how do I access the wizard you
are talking about. Thanks.

Open the form in Design View.
Click on the ToolBox tool button (the icon looks like a hammer and
wrench).
When the toolbox opens it will display some of the available controls.
Depress the Wizard tool button (the wand with stars) that's set's up
the control wizard.
Then left-click on and drag the OLEUnbound control onto your form.
The wizard will open a dialog.
Select From File. Click on the Link check box, Then Browse to the
Excel file you want to show. Save the changes.

If you intend to permit spreadsheet editing from the form, right-click
on the new control. Choose properties. Click on the Data Tab. Set the
Enabled property to Yes and the Locked property to No. Save the
changes.