Wildcard in append query

[Mary Fran]

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.

 

[Michel Walsh]

Hi,

None that I know.

Hoping it may help,
Vanderghast, Access MVP

 

[JohnFol]

If you double click on the table in the query grid this selects all fields
individually. Then, de-select the autonumber

 

[Mary Fran]

Oh, thank you SO much - you have just saved me from carpal tunnel syndrome!