Wildcard in append query

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

Guest

Is there any way to append all fields except the autonumber primary key in a
query without having to specify all the fields? Like a wildcard with an
exception? Thanks in advance for any help.
 
If you double click on the table in the query grid this selects all fields
individually. Then, de-select the autonumber
 
Back
Top