Preserving the Hyperlink using DoCmd.TransferSpreadsheet

  • Thread starter Thread starter Beans
  • Start date Start date
B

Beans

Hi, I have a field that is configured as a hyperlink but when I export it
using a query and the DoCmd.TransferSpreadsheet the hyperlink is converted to
text.

Interestingly enough if I export the table using Tools Office links and
analyze it with Microsoft Excel, the hyperlinks are preserved.

Any suggestions.

thanks
 
well you could always use the vba code for analyse it with excel not
that i know what it is this question is better for a vba group they
should be able to help you
 

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

Similar Threads

Can a query field display as datatype hyperlink? 1
Will not auto open .jpg 1
Word hyperlink not showing once merged 0
Hyperlink Part 1
update hyperlink values but not displayed text 1
Docmd.TransferSpreadsheet 5
create hyperlink & append table 1
MS Access: Creating hyperlink field in a query 0

Back
Top