How do I export a Access table hyperlink field/column to Excel ?



I've unsuccessfully attempted to export a hyperlink field to Excel (2003)
from a table in Access (2003). I used the xfertoexcel macro and the data
type being Hyperlink. In the macro I defined the path with the extention
being .xls so it open automatically in Excel, however it places a ' in each
of the fields at export time, which isn't recognized in Excel. My hope was
that with the hyperlink field in Excel you could just click on it. Thank you
in advance for any and all comments. I did suceed in exporting the same table
as a .htm file that opened and performed correctly.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question