Append query without field names

  • Thread starter Thread starter John
  • Start date Start date
J

John

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
 
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
Click to expand...

INSERT INTO target
(SELECT * FROM source)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select From choice of tables 3
Append Queries in 2007 5
Append only Null records in table 2
Brackets in the Append To row of an Append Query 2
Problem With Autonumber & Append Query 2
Appending records to new table using field names as values 2
"Error 3061: Too few parameters. Expected 1" - But No External Refs? 2
query problem 1

Back
Top