Import Excel Table Hyperlink to Acces 2003

[victorio0704]

I have an Excel table with about 3000 hyperlinks I tried importing to access,
when i do the link dissapears, only text appear is there a way to import into
access the ecel table and have the links working still

 

[Arvin Meyer [MVP]]

You don't need to have a hyperlink to make the text work that way. As a
matter of fact, leaving it as a text field is faster, smaller and has less
chance of corrupting. On the plus side, you can also sort and index a text
field, but not the hyperlink datatype.

To use a text field as a hyperlink simply add a double-click event to the
textbox in your form:

Private Sub txtBoxName_DblClick(Cancel As Integer)
Dim strPath As String
If Not IsNull(Me.txtBoxName) Then
strPath = Me.txtBoxName
Application.FollowHyperlink strPath
End If
End Sub

 

[victorio0704]

I migth not understand what you are saying, the links that i have in Excel
documents are to PDF documments, i update the table dayly, mine idea is for
the person once is donde the query in all the other factors in the table can
simply click on the link and get the document they need it already works in
excel but mine idea is todo it in acces to cross reference other peoples table

 

[Arvin Meyer [MVP]]

A hyperlink datatype is not searchable or indexable. A text datatype is.
Therefore it makes sense to store the path as a text file and use:

Application.FollowHyperlink

to actually open the file.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com