Thanks… I'll try out the script.
The reason for frequent updates is that we have a legacy system which we haven't yet fully migrated from Access2000. As a result we need frequent updates to the live mySQL database. I'm currently moving everything over to a mySQL/PHP interface, so I don't want to waste too much time on an elegant solution to getting the data out of Access.
Thanks again for the script tip