Hi Jim

where are you putting the hyperlink information - in a field in the access
table?

Cheers
JulieD

"Jim" wrote in message
...
I have an access 2000 database that contains CompanyID, Company Name, and
URL

I have an Excel spreadsheet from another source that has CompanyID, and
some
other misc info.

How can I program a macro to search the CompanyID in Access and create the
hyperlink on CompanyID in Excel?