Transferring data from one table to another

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

Guest

Is there a way to transfer data from one table to another. Have one select statement pull data under certain requirements then insert that data into another table?
 
Is there a way to transfer data from one table to another. Have one select statement pull data under certain requirements then insert that data into another table?
Click to expand...

Yes; it's called an Append query. See the online help for Append.
 
I have tried the append query, but I always get a message that I am affecting 0 rows.
Click to expand...

"Doctor, I don't feel good. What should I do?"

Please post the SQL view of your append query. Clearly you're doing
something wrong, but since I cannot see your query nor your table
structure there's no way for me to suggest what it might be.
 
Back
Top