>Thanks - along the right direction, but not very multiuser.
Then do it to a temp file first THEN append in directly.
>>Coming in late on this thread, but ...
>>
>>How about ALTER TABLE and RENAME COLUMN (to 'xxxx') right before the append, and the rename the column back right afterwards?
>>
>
-- John Kiernan
"Maybe Amelia Earhart was just stealing the plane".