Hi Kenneth,

We don't really want the end user to have access MS Access, we would prefer them to use excel if at all possible. I'm more than happy to go with the harder option as it would be good to learn, but if you want to provide examples of both methods that would be great.

Of course, once I get the Excel communicating with Access, i'll no doubt be posting in the Access forum as, well, Access is alien to me tbh!

Thanks,