Is it possible to Linking to Embedded Excel Spreadsheet?

[Bart]

I am trying to link a table to an EMBEDDED spreadsheet. Is
this possible? The reason that I am not linking it to an
external spreadsheet is becuase I am making a product for
the end customer, and the file will shift hands probably
multiple times. I do not always know where the directories
will be on their drives. From what I understand, the
linked tables are linked to hard-coded directories and not
to "relative" directories (such as a sub-folder). An
alternative I have thought of is to use vba to check for
the link and re-establish it if necessary to the correct
file. However, there are a few problems I will run into
with that. Please advise on if it is possible to link a
table to an embedded spreadsheet, and if so, how?
Thanks,
Bart

 

[John Nurick]

Embedded in what?

I am trying to link a table to an EMBEDDED spreadsheet. Is
this possible? The reason that I am not linking it to an
external spreadsheet is becuase I am making a product for
the end customer, and the file will shift hands probably
multiple times. I do not always know where the directories
will be on their drives. From what I understand, the
linked tables are linked to hard-coded directories and not
to "relative" directories (such as a sub-folder). An
alternative I have thought of is to use vba to check for
the link and re-establish it if necessary to the correct
file. However, there are a few problems I will run into
with that. Please advise on if it is possible to link a
table to an embedded spreadsheet, and if so, how?
Thanks,
Bart

 

[Bart]

Embedded into the database itself, such as an OLE object
on a form

-----Original Message-----
Embedded in what?

I am trying to link a table to an EMBEDDED spreadsheet. Is
this possible? The reason that I am not linking it to an
external spreadsheet is becuase I am making a product for
the end customer, and the file will shift hands probably
multiple times. I do not always know where the directories
will be on their drives. From what I understand, the
linked tables are linked to hard-coded directories and not
to "relative" directories (such as a sub-folder). An
alternative I have thought of is to use vba to check for
the link and re-establish it if necessary to the correct
file. However, there are a few problems I will run into
with that. Please advise on if it is possible to link a
table to an embedded spreadsheet, and if so, how?
Thanks,
Bart

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[John Nurick]

Hi Bart,

As far as I know this isn't possible. In any case it's usually
undesirable for an Access application to store data in spreadsheets; for
one thing it means you can't ensure relational integrity because you
can't prevent the spreadsheets from being changed outside the
application. Instead, keep the data where it belongs - in tables in the
database - and export it to an Excel workbook when it's needed.

Embedded into the database itself, such as an OLE object
on a form

-----Original Message-----
Embedded in what?

I am trying to link a table to an EMBEDDED spreadsheet. Is
this possible? The reason that I am not linking it to an
external spreadsheet is becuase I am making a product for
the end customer, and the file will shift hands probably
multiple times. I do not always know where the directories
will be on their drives. From what I understand, the
linked tables are linked to hard-coded directories and not
to "relative" directories (such as a sub-folder). An
alternative I have thought of is to use vba to check for
the link and re-establish it if necessary to the correct
file. However, there are a few problems I will run into
with that. Please advise on if it is possible to link a
table to an embedded spreadsheet, and if so, how?
Thanks,
Bart

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.