..In your excel spreadsheet, add another column alongside the hyperlink.
In that new column, put a formula:
where A2 is the cell with the hyperlink in.
It will give an error initially.
Press ALT+F11 to get into the VBA editor in excel, insert a module and paste in the code from here:
Then you will see your new hyperlink column will contain both link and text separated by #. When you import into access and change the field type to be hyperlink it will now work!
If you want a sample spreadsheet with this working let me know.