Access to CSV

[CJ]

Hi
Newbie & very much techno idiot
I'm exporting Access files to CSV. The Access file contains a hyperlink
column containing web links. During the conversion to CSV # are inserted
(automatically?) at the beginning & end of he web address e.g.
#www.microsoft.com#. This corrupts the link taking almost anywhere but the
intended web address.
Any ideas on how to prevent this automated inclusion of # during the
conversion?
Thanks

 

[Douglas J. Steele]

Unfortunately, hyperlinks in Access have octothorpes (# characters) in them.
The data in a Hyperlink field can contain up to three parts in the following
format:

displaytext#address#subaddress

What you could try doing is create a function that returns all of the rows
in your table. Rather than the hyperlink field itself, use the Replace
function to remove the octothorpes:

Replace([NameOfHyperlinkField], "#", "")

Export the query rather than the table.

 

[CJ]

Many thanks for taking the time, Doug. I'll give it a try

Unfortunately, hyperlinks in Access have octothorpes (# characters) in them.
The data in a Hyperlink field can contain up to three parts in the following
format:

displaytext#address#subaddress

What you could try doing is create a function that returns all of the rows
in your table. Rather than the hyperlink field itself, use the Replace
function to remove the octothorpes:

Replace([NameOfHyperlinkField], "#", "")

Export the query rather than the table.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi
Newbie & very much techno idiot
I'm exporting Access files to CSV. The Access file contains a hyperlink
column containing web links. During the conversion to CSV # are inserted
(automatically?) at the beginning & end of he web address e.g.
#www.microsoft.com#. This corrupts the link taking almost anywhere but the
intended web address.
Any ideas on how to prevent this automated inclusion of # during the
conversion?
Thanks