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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Seriously, I need ideas. Fields not transferring from table to table 3
How to export table from outlook into ms access table? 0
How to Populate Data from a table to another 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
There is missing a , sign ??? 2
Transfer data between Access 2003 & 2007; Data does not show on formheader 1
Transfer data between Access 2003 & 2007; Data does not show on formheader 2

Back
Top