Updateing multiple tables

[B+ve]

How can I update multiple tables (3) from one linked Excel file. The update
query seems to be designed to only handle one destination table.

 

[John Spencer]

Probably you need to run three update queries. However, if the three tables
are related and you can create an updatable select query on the three tables
and the Excel file, you may be able to update them all at once.

This trivial example updates two tables at once

UPDATE FAQ_BU INNER JOIN FAQ0
ON FAQ_BU.fID = FAQ0.fID
SET FAQ_BU.fSubject = [FAQ0].[fSubject]
, FAQ0.fSubject = [FAQ_BU].[fSubject];


John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County