Copy information from datasheet to datatsheet

[Guest]

I have a datasheet - named A and would like to creat a macro to automatically
copy the information in Salary Draft to another datasheet named B. I had
tried numerous actions which I can't reach the desired results. Thanks in
advance

 

[KARL DEWEY]

Are you using Microsoft Access or Excel? This newsgroup is for Access the
relational database.

 

[Guest]

Both datasheet are in MS Access

Are you using Microsoft Access or Excel? This newsgroup is for Access the
relational database.

 

[bob]

create an append query based on table A to copy (append) the data to table b

create a macro that runs that query

Bob

 

[Guest]

Thanks, Bob. It works perfectly well and I managed to do a delete query
after appending the infor.