Is there a way to imbed an excel spreadsheet in a database, and have that

  • Thread starter Thread starter Richard S
  • Start date Start date
R

Richard S

Is there a way to imbed an excel spreadsheet in a database, and have that
spreadsheet linked to a query or tabke within that database? That way, you
can send it as a package to someone who has access on their machine, and
they can view the spreadsheet with the query returned by the DB. Kind of a
package deal, where thay work together, no need to have paths defined
between the 2.

Any help is greatly appreciated.

Thanks,

Rick
 
Hi Rick,

This might be possible, but I'm not going to waste time trying. Even
though the spreadsheet might be embedded in an OLE field, you'd still
need to launch Excel to manipulate it, and IMHO it would be much simpler
to work with an xls file than with an embedded object.

If you're desperate to distribute a single mdb file rather than (say) a
zip file containing an mdb and an xls, you could store the xls file (or
template) in a field in the mdb for distribution, and then have your
code extract it do disk whenever needed. I'd do this not by _embedding_
the xls file, but by using AppendChunk to store its _contents_, and then
GetChunk to retrieve them from the field to a string which can then be
written to a disk file.
 
Back
Top