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

[Isabel]

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

 

[Darren Stanger]

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

 

[John Nurick]

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?

 

[John Nurick]

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.