Access to CSV

  • Thread starter Thread starter CJ
  • Start date Start date
C

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
 
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.
 
Many thanks for taking the time, Doug. I'll give it a try

Douglas J. Steele said:
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)


CJ said:
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
Click to expand...
Click to expand...
 
Back
Top