how to link a cel on an Excelsheet with a database field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Isabel - 27 Aug 2004 20:22 GMT

I would like to display a specific cel on an Excelsheet in
a field in a database.
Could anyone give me a few tips?

Many thanks in advance!!

Greetings,

Isabel

Reply to this Message

Darren Stanger - 27 Aug 2004 21:53 GMT

It sounds like we are trying to do the same thing. I set
up a field of type hyperlink in an Access table. Then
from an Excel worksheet, I copy a cell. Then I go back to
the hyperlink field in Access and try to Paste as
Hyperlink but the option is not active from the Edit
menu. I am able to copy text from Word to the Access
hyperlink field without fail.

Sorry I don't have a solution for you but will keep
trying.

Darren

>-----Original Message-----
>I would like to display a specific cel on an Excelsheet in
[quoted text clipped - 7 lines]
>Isabel
>.

Reply to this Message

John Nurick - 28 Aug 2004 10:31 GMT

Hi Darren,

If you want to point an Access hyperlink field to a specific cell in a
workbook, it doesn't seem possible with the standard Edit Hyperlink
dialog, but you can do it by pressing F2 while the insertion point is in
the field. This displays the actual contents of the field, which will be
like this for a link to a whole workbook:

Text To Display#C:\Folder\Subfolder\Workbook.xls#

In principle you can then just add a single-cell range or range name
like this

Text To Display#C:\Folder\Subfolder\Workbook.xls#'Sheet Name'!A1

but I'm having some problems making it actually work.

>It sounds like we are trying to do the same thing. I set
>up a field of type hyperlink in an Access table. Then
[quoted text clipped - 21 lines]
>>Isabel
>>.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

John Nurick - 28 Aug 2004 10:05 GMT

Hi Isabel,

It depends what you mean by "link", "display", and "field".

You can't have a live link between a single field in a record in an
Access table and a single cell somewhere in an Excel workbook.

You can use a linked table in Access to connect to a range of cells in
Excel - and that range can be as small as a single cell, which would
appear in Access as a table with one record containing one field.

Or you can use Automation to run Excel VBA code in Access to get or
manipulate anything in the workbook.

Would you like to give some more information about what you want to do?

>I would like to display a specific cel on an Excelsheet in
>a field in a database.
[quoted text clipped - 5 lines]
>
>Isabel

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message