Inserting records directly from Excel into Access?

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 had a similar problem. I found out that you can link directly from access to excel. Use the table wizard to make a new linked excel list containing all of the data that you need.
The next step should be to create a button to update the info. I think there is an option to write all data from a table (in this case your friends excel sheet) into a record. This should only add new data as existing data will just be replaced.
This means that it might not delete old email addresses.
Thats all i can think of - im not too sure - hope its of some help!

Qoo

Thanks for your reply.

When I import the hyperlinks from the excel spreadsheet, they become plain 'text' fields in Access. Furthermore, Access doesn't allow me to change the field type for linked tables?
Any ideas on how to keep the linked data as hyperlinks (without losing the hyperlinked addresses aswell?)
The hyperlinks are linked to Word documents.