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.
 
Back
Top