Reading & inserting records directly from Excel 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

 

[jeremie_ingram]

What if you established a Link tbl to the document in question, then created an append query that would add them to the tbl you need. If you set the link as the PKEY for the tbl, then it would not overwrite or erase the existing ones, only add the new.

You could then add a button somewhere with a little code behind it to run the query and refresh the tbl view in the form.

 

[Mile-O]

How many more forums am I going to find this post in today?


Double Post

 

[reimondo]

Thanks for your reply.

I've tried linking the table to the excel spreadsheet but i have a small problem.
When I create a link to 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.