Hyperlink duplication

[pwicr]

Hi,

We are trying to export information from Access to Excel. When we export the hyperlink, it is fine in Access but once it gets to Excel, it has duplicated itself with a # on either end of the second hyperlink rendering the hyperlink unusable.

How do we prevent this from happening?

Crystal

 

[vbaInet]

If you use the Import & Export wizard, on the first page remember to tick to the Export data with formatting and Layout and it should export fine.