How to automatically populate a table field with an excel hyperlink

[snwbrder01]

Hi,

I am a new user to this site, but I have looked at it before and it has been very helpful. So thanks for that everyone. Back to my question, is it possible to automatically populate table fields with hyperlinks to all worksheets within one excel file? For example:

Say I have Excel File "Client_Names.xls" with these worksheets; Sheet1, Sheet2, Sheet3, Sheet4, etc..

Can I automatically populated table fields with a hyperlinks to each Sheet1, Sheet2, and so on?

I am currently entering hyperlinks manually into each table field for each worksheet, which is time consuming because I do this monthly with multiple files that each contain multiple worksheets.

I enter the Client Name, then copy the data path and paste, and then copy and paste the sheet name to create the hyperlink as follows;

Client Name#H:\Accounting\Tax\Sales\Client_Names.xls#Sheet1#

Is there a quicker way than this? I did not see any posts. Thanks for your help!

PS I am using Access 2007.