Importing URLs from Excel

[tfmurphhk]

I have successfully imported many URL's from Excel into an Access field that was set as a hyperlink field.

However, when I click on that URL in the Access form.. it goes nowhere.



Alternatively, if I manually type the URL into the same field, when I click on the URL it opens a browser window and goes to the correct URL.

Why does it make a difference between imported URL's and manually typed URL's?

I must be doing something wrong. What... and more importantly, how can I correct it.

Thanks

Tom

[June7]

Last time I saw a thread with this same question the conclusion was that the hyperlink will not import as a hyperlink. This thread discusses that export to htm file first then import the htm to Access allowed the hyperlink to work. I haven't tested, but if you want to http://windowssecrets.com/forums/sho...el-into-Access