how create append query with all columns in both tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do I do this? All I can see is an asterisk (which i dont want), I need
all columns in the source and target table to be listed in the query. After 2
hours messing ith this, I can't figure it out. My table has 200 columns so I
cant type this in!
 
Double-click the title bar of the table in the upper part of the query
designer, and all fields will be selected. Now click and hold the default
mouse button on one of the fields, and drag to the field row in the lower,
grid portion of the query designer.
 
You must log in or register to reply here.

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

Append Query Issue 0
Append queries - Column Headers 2
Appending queries 4
Numeric Field Overflow when appending date - how to convert it to text 1
Append Query, New Column help 1
How to append running number 1
Access 2007 - append query only appending 0 rows??? 0
Append Query - destination table not available 6

Back
Top