Reading data from Excel & inserting records directly into Access?

[Reimondo]

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

 

[BNPMike]

Wouldn't it be satisfactory just to import the excel data into your table using the import facility rather than writing your own interface?