Import Hyperlinks

  • Thread starter Thread starter Paul Gregory
  • Start date Start date
P

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
 
This worked for me:

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

I hope it workes for you to.

/Eva




"Paul Gregory" skrev:
 
Thanks


Eva said:
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
 
Back
Top