Excel sheet in Access Form

[Burger]

I have Excel sheet of 60x20 cells.
What I would like to do in Access is have a form in which this Excel sheet
is included (there are a couple of reasons why I want this in Access). That
is, you can fill in the Excel sheet for each observation (so not just to
show data in the Form but also to enter data from the Access form to the
Excel sheet). I'm not sure how Access should save this (perhaps a seperate
sheet for each observation?)

Is including an Excel sheet possible in Access?
I have tried to link a Table to the Excel sheet. But this is not the same as
having an Excel sheet within a Access form. Moreover, if I subsequently want
to use that Table to make a form, I get the error message "You can select up
to 6 fields to use in your chart" (while I need 20).

 

[Tom van Stiphout]

On Sun, 23 Dec 2007 22:16:29 +0100, "Burger" <[email protected]>
wrote:

You can embed an Excel sheet in an Access form - thanks to the E in
OLE. Once you step into that control, you are in the Excel environment
and can do anything Excel can.
Try the Unbound Object Frame.
Communicating between Access and the embedded object is an advanced
topic.

-Tom.

 

[Jeanette Cunningham]

Answered in your other post on the same topic