Dorris,

>If not, you could try the copy to .txt, append from .txt suggested by David Stevenson, but it seems a long way to go for a simple command.

I think COPY TO TYPE DELIMITED and APPEND FROM TYPE DELIMITED is the simplest way to solve his problem, since the field names do not match.