Well i am taking some data (just certain columns) from access' also, i am also adding more to the sql, (my mapping between the two works fine)  but until i get my software to...

o yea i forgot, i will be using VS2005 windows form to make this happen, pulling from access '97 and inserting into sql server 00 or 05

I close the connection after i have looped though everything... O by the way this is old shcool vb6 here is my code if that helps:

  count = 0

'On Error...