Hi There,

I'm just doing some work in Access and I can't for the life of me figure out how to add stuff to a table I have a collection of filenames 'mColFiles', I want to loop through the collection and add each filename to a table called 'Hyperlink_Ids_table', The name of the fields I wish to add them to is called 'Filenames'.

Excuse my stupidity but I have not worked with Access and can't figure out the answer from the help files.

Thanks

Maddy