If you know the format of the tables, there's nothing magical about it. All you do is read the Access table, do any translation that you need to, and write it to the SQL table. The connection technology you use for either one is up to you. In VB.NET, all this stuff is supplied in the .NET BCL. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome