Excel as input 'window' in Access (OLE)

Is it possible to use the Excel OLE bound object for input in an Access application ?

I am able to link this OLE Excel object to my database table and show the contents of the table, but it doesn't update the records when i change them in this 'Excel-view'

Any suggestions to let this work ?

Luc,

First, check the .UpdateOptions property of the OLE object. Also,
how are you connecting the Access data to the Excel OLE object?
Using the DataSource or code in the linked Excel file?

I have set the Row Source property via the properties to the Tablename

Then i have set the updateproperties via Code as following

OLEUnbound13.UpdateOptions = acOLEUpdateManual
OLEUnbound13.Action = acOLEUpdate
OLEUnbound13.Save
OLEUnbound13.Requery

Still, there is no update of my table and the Excel view is refreshed to the original values.

Luc,