Thanks, that seemed to do it

Bruce,

I amended your code

--------------------------------------------------------------------------------------------

declare @sql ...

Bruce,

I altered the code to insert the records

----------------------------------------------------------------------

declare @sql ...

Jack,

yes I have, and I am trying to pursuade the boss to move to it, but this sort of method will have to do for a few months till we...

Thanks for the suggestion, but this code has to be relatively generic and run as part of a batch on a customers site.

The tables that require copying will grow as...

Sorry I thought it was working, changed code to

declare @sql varchar (8000)

Declare @tablename varchar (255)

declare @columns as varchar (8000)

declare @field as varchar (100)

DECLARE locTable_cursor CURSOR

FOR SELECT NAME FROM...

Thanks for the quick response, added in some code to get the field list and it works great.

John