Eric,

Thanks for your help.
I wanted to do it in VB since a user will have to do and Update on a monthly basis. He will need to append a Access table to a SQL7.0 table ( both tables have the same table structure).

Thanks,