OLE path - can't see it in Access table

H

Harold Good

Hi,

I'm experimenting with copying an Excel graph as a linked object into Access
to view as part of a report. When I paste the link into the Access table, it
works fine and also appears ok in the report.

But since I have about 200 of these to copy, each from separate Excel
spreadsheets, for 200 different projects, I don't want to have to open each
spreadsheet to copy the graph into it's appropriate row in the Access table.
I'd rather just copy one link into each of the 200 rows, then edit the path
in the link with the appropriate spreadsheet name. But I can't find the path
of that link that I've pasted into Access.

But if I paste that same link into Word, I can easily read and edit the link
and path as follows:
{LINK Excel.Sheet.8 "C:\\HG\\My Access\\TSC Database\\TSC Database
Original\\Yoay Progress Chart.xls" "Progress![Yoay Progress
Chart.xls]Progress Chart Progress" \a \p }

Can anyone tell me how I can read this link path in Access, similar to what
I see above in Word? Why won't Access let me see and edit this info as Word
does?

I don't do VBA, but does anyone have any suggestions as to how I can do this
with 200 graphs from 200 spreadsheets without it taking forever by doing it
manually?

Thanks,

Harold
 
Top