Import Hyperlinks

[Paul Gregory]

I have a CSV that I would like to import into a table. This CSV file
contains hyperlinks. During the import Access recognises that the Hyperlinks
are there and automatically sets the Data Type for the field to Hyperlink.

However when you try and use the imported hyperlink it doesn't work. When
you view the properties of the hyperlink the imported data has been placed
into the "Text to display" but not into the actual "Address".

Is it possible to import these hyperlinks so they work?

Thanks

 

[Guest]

This worked for me:

UPDATE Table SET Table.[column] = "#" & "http://" & [column] & "#";

I hope it workes for you to.

/Eva




"Paul Gregory" skrev:

 

[Paul Gregory]

Thanks

This worked for me:

UPDATE Table SET Table.[column] = "#" & "http://" & [column] & "#";

I hope it workes for you to.

/Eva




"Paul Gregory" skrev:

I have a CSV that I would like to import into a table. This CSV file
contains hyperlinks. During the import Access recognises that the Hyperlinks
are there and automatically sets the Data Type for the field to Hyperlink.

However when you try and use the imported hyperlink it doesn't work. When
you view the properties of the hyperlink the imported data has been placed
into the "Text to display" but not into the actual "Address".

Is it possible to import these hyperlinks so they work?

Thanks