No. There is only one destination table allowed, unfortunatilly. The easiest
way I have found is to copy the query and change the destination table.
"DSmith" <Donna@nospamRES-xraynews.com> wrote in message
news:O$IGJ$iLEHA.2068@TK2MSFTNGP11.phx.gbl...
> Is it possible to append to two tables with the same append query at the
> same time?
>
>
RE: Delete Table ... It isn't a back-end database.... The reason I want it to run in the destination... > query is the best approach. ... >> run a delete query then append query to repopulate but can this be done from ... (microsoft.public.access.modulesdaovba)
Re: To get some columns of a db in an other db ... Open the destination database.... Create a query on the table with the 3 columns, ... Change the query to an append query, and append the results to your ... (microsoft.public.access.tablesdbdesign)
RE: Importing Text Files ... Use the query builder.... On the menu bar select Query then select Append Query.... > data to (the destination table). ... >> When you create the append query to move the data to the target table what ... (microsoft.public.access.externaldata)
Re: append query ... The destination table MUST have a field for each field from the source you are ... A MAKE Table query automatically builds the structure and then inserts the records. ... There must be a one to one field correspondence in an append query.... > My understanding was that an append query can append records even when some ... (microsoft.public.access.queries)
Re: Data Driven Query Task and Parameterized Update ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)... > I'm running into difficulty usinging parameters in my data driven query... > destination table to see if a record exists. ... The error refers to an access violation.... (microsoft.public.sqlserver.dts)
