Excel spreadsheet from Access table + keep hyperlinks

E

Ellen

Hello,
How can a 2002 Excel spreadsheet be made from an 2002
Access table where the hyperlinks stay in tact?

Thanks,
Ellen
 
O

onedaywhen

Ellen said:
Hello,
How can a 2002 Excel spreadsheet be made from an 2002
Access table where the hyperlinks stay in tact?

Thanks,
Ellen
Click to expand...

Another case of MS Access being confused with Jet? There is no native
Jet data type for 'hyperlink'. Jet sees a 'Hyperlink' column/field
data type as 'Memo' (in ADO terms, adWChar: 'a null-terminated Unicode
character string') with a 'hyperlink' attribute (in ADO terms, <Column
object>.Properties("Jet OLEDB:Hyperlink")=True) which is only used by
the MS Access UI.

In short, outside of the MS Access UI the hyperlinks are seen as plain
text. So after you have imported the text to your Excel column you
must format it as 'hyperlink' in the Excel UI e.g. manually, using VBA
code in the workbook or via automation.

--
 
Top