Append query without field names

John · Mar 28, 2009

Hi

Is there a way to have an append query without the field names so whichever
filed names match between the source and destination tables they get copied?

Thanks

Regards

John W. Vinson · Mar 28, 2009

Hi

Is there a way to have an append query without the field names so whichever
filed names match between the source and destination tables they get copied?

Thanks

Regards

INSERT INTO target
(SELECT * FROM source)

John · Mar 28, 2009

wow that easy

thanks john..

Regards

John W. Vinson said:
INSERT INTO target
(SELECT * FROM source)