reimondo
07-29-2003, 08:08 AM
Hi,
I'm helping a friend build an access database and have a problem.
I currently have a list of hyperlinks contained within an excel file. At the moment, I have to insert each hyperlink one by one via a RunSQL statement using a macro. This method works but will be rather troublesome for my friend to update the list of links later on (as he does not know much about Access).
I wish to be able to create a button in the form that can automatically read each hyperlink (each cell) from the excel file, and insert them into a sub form table within access.
So that later on when my friend wants to add new hyperlinks, he can simply add them via Excel/Word (the hyperlinks can either be stored in Excel or Word)
Does anyone know how to do this? I am only familar with the Access interface design and macros, but not very familar with VB.
Your help will be most appreciated,
Raymond
I'm helping a friend build an access database and have a problem.
I currently have a list of hyperlinks contained within an excel file. At the moment, I have to insert each hyperlink one by one via a RunSQL statement using a macro. This method works but will be rather troublesome for my friend to update the list of links later on (as he does not know much about Access).
I wish to be able to create a button in the form that can automatically read each hyperlink (each cell) from the excel file, and insert them into a sub form table within access.
So that later on when my friend wants to add new hyperlinks, he can simply add them via Excel/Word (the hyperlinks can either be stored in Excel or Word)
Does anyone know how to do this? I am only familar with the Access interface design and macros, but not very familar with VB.
Your help will be most appreciated,
Raymond