Editing Excel spreadsheet inside MS Access field as an OLE Object.

[nmsustudent]

I am using the ActiveX "Microsoft Excel 11.0 Object Library" and am trying to populate cells with values before opening the fields in an Excel spreadsheet. The data is stored in a field as an OLE Object.

Any clue?

[Micron]

AFAIK, you cannot. You'd link the spreadsheet as a table instead if you want to modify it's data - unless you're willing to edit the source file and replace the db object. Many of us here would not store such objects (including pictures) in Access tables. It leads to problems that you don't need, given that there's more reliable ways to link data or images.

For the record, a spreadsheet has columns and rows, where the intersecting space is called a cell. A table has fields and rows, but the intersecting space is seldom referred to as a cell. So it's not clear to me if you're trying to "populate" spreadsheet cells before you open the OLE spreadsheet object or what. Even if you stick with embedded spreadsheets, I would not do so if you intend to modify their data, especially on a regular basis. Embedding the object as a historical record would be somewhat acceptable, but then again, I still would not do so. It's one of those things you can do in Access that many of us wouldn't.

[June7]

AFAIK, Excel sheets cannot be edited through a link nor as embedded object in OLEObject control.

[Micron]

I didn't mean to imply that you could edit linked spreadsheet data, rather that you'd edit the source and use the link to see the changes.

[pbaldy]

FYI, I moved your thread out of the forum suggestions area.