Thanks Jan and Lowell for the help,

I must have made a minor change to the code before I copied and pasted it, but yes I got a totally different error msg... I will try to be more careful.

To answer your questions I am just slowly building up my skills in SQL.... This is just a test query to see how to transfer data. Thanks for the more efficient route.