I have two tables with the same names and structure in two different folders. They include meno fields. I want to copy (append) records from table in folder a to similar table in folder b (excluding deleted records). What is the best way of doing this? Pseduo code

copy from c:\a\b\table to c:\x\y\table for not deleted

Please supply code thanks.