INSERT INTO......SELECT

[SweetDot]

Is there anyway to select a record from table A and insert it into table B without listing the field names? there are 30 fields, and it's such a pain to have to do that. I need to append to Table B, so I can't do select Into.....
Please help...

thanks

 

[genomon]

INSERT INTO tableB SELECT * FROM tableA WHERE........

 

[lespaul]

genomon's solution will work as long as you want to insert all the fields from table a into table b (so the structure has to be the same).