Embedded Excel spreasheet

[Mr930R]

If I have an Excel spreadsheet embedded in my Access file, can I access the cells in the spreadsheet without detaching first?

Fred Emmerich

 

[welshgasman]

By default, only if the DB is not open, else Excel will complain and offer Read Only.
There is a way if you link to it in a certain way, but I cannot remember or find it now.

Found it.

Edit Linked Excel Data from Access

This article describes two methods of making linked Excel files directly editable in Access

www.isladogs.co.uk

 

[Mr930R]

More detail: I have a database app that uses Access files to store the data. One option it has now is to be able to read data from an external Excel sheet. The only issue is having to transport a .xls along with the .mdb to make it work. I was wondering if the Excel file could be embedded in the .mdb and read from there without detaching. I had another thought: is an embedded file going to be included in the 2GB file size limit of .mdb?

 

[Micron]

if you import and don't link, it becomes a table, not a spreadsheet, so it's editable. Yes it will be part of the file size.

 

[Mr930R]

It would not be imported, it would be an embedded object.

 

[Micron]

Embedded in what? Can you describe what you're doing?