Copy information from datasheet to datatsheet

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

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
 
Are you using Microsoft Access or Excel? This newsgroup is for Access the
relational database.
 
create an append query based on table A to copy (append) the data to table b

create a macro that runs that query

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