append to multiple tables

[GraemeG]

hi,

I have an append query which I am trying to append to multiple tables at once is this possible.
I have the following sql which isnt working at the minute.

INSERT INTO [MOT:Bathroom] ( propref )
INSERT INTO [MOT:Bedroom1] ( propref )
INSERT INTO [MOT:Bedroom2] ( propref )
SELECT Propertyextract.propref
FROM Propertyextract;

Thanks

 

[pbaldy]

I don't think you can do that. The syntax allows for a single table or query. The only way you might be able to do it (with a single append query) would be to specify a query instead of a table, with that query having fields from all 3 tables. Of course, that query couldn't be read-only, which a lot of multi-table queries are:

http://allenbrowne.com/ser-61.html