>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).
I saw a way of inserting the reference to a MDB into a SQL query but I can't remember where. Maybe you better ask in the SQL section.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com