Hyperlink based on field value

[Jonny]

I have excel file with two fields:

Model | Website
--------------------
Toyota | Press..
Honda | Press..

Website column is a function:

=+HYPERLINK("http://www."&A3&".com","Press..")

When importing to Access , the link is disappeared.

How to keep the 'Website' field value, based on 'Model' (as in Excel)?

 

[Pat Hartman]

The import to Access pulls data only. It doesn't run calculations. To import the link, you would need to create a macro that formats the link and saves it as data in another column.

 

[Jonny]

Less or more I understand what you mean , but have no idea how to implement this.
Could you please help with this sample?

Thanks