Append query using wildcard character for fields?

[lgbatdw]

I am using Access 2000. Is there a way to do an append query using a wildcard character instead of having to name all the fields? I know both table structures have to match. If this could be done, it would make one less query to have to address if/when table structure changes were made.

Is something similar to below possible? I get a syntax error - incomplete query clause.

INSERT INTO tblMasterBillingCodes.*
SELECT tblMasterBCTemplate.*
FROM tblMasterBCTemplate;



Linda in MN

 

[lespaul]

As long as both tables have the same structure, this should work, the only thing I can think of is missing parens:

INSERT INTO tblMasterBillingCodes.*
(SELECT tblMasterBCTemplate.*
FROM tblMasterBCTemplate);

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[PHV]

I think the correct syntax is:
INSERT INTO tblMasterBillingCodes
SELECT * FROM tblMasterBCTemplate

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886