Append Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to copy data from one table and insert it into another table in the
same database. An Append Query would be perfect except, I need to be able to
run the query and adjust the parameters until I narrow down my search and
have only the correct transactions. In other words, I don't want to actually
move the data until I've had a chance to review and make changes first.

I'm thinking something along the lines of Query 1 being the query I use to
find the record(s) I'm looking for and Query 2 (preferably linked to the
first so I don't have to adjust the information) being the append query that
adds the information.

Or second senario, a macro that appends that information only when I've used
the query to narrow down to the records I need.

I've used Append Querys and recorded a few macros, but I'm not that familiar
with either. In the long run, which would be better? In the short run, how
do I set something like that up?
 
I can think of two simpler solutions.

One: create a select query and keep running it until you are sure of the
records returned. Then in design view go up to Queries, Append.

Two: go ahead and create the Append query in design view but instead of
running it, go to View, Datasheet View to see the records. Once you are sure
of the records, then Run it.

Either way, make a backup of the tables involved or the entire database
first. As it seems if you don't have the process nailed completely down,
there is potential for making a big mistake.
 
Your idea of using two querys would seem to me to be the simplest way to do it.
Query1 could be a Select query based on the source table that includes all
the fields you to append to the destination table. Query2 could be an append
query that uses Query1 as its source and appends to the destination table.

Now you can play with Query1's criteria until you have the transactions your
want, save the query and run Query2. Since Query1 returns only the rows you
want to append, Query2 will only see the rows included in Query1 and append
them to the destination table.
 
Back
Top