Hi, another problem. I need to copy a table called "AR" to another table "Acc" in the same database, how do i do it? Can I use INSERT ? I used but without much success. Or is there another way? The code I used is as per below:

Adodc1.RecordSource = "INSERT ACC (SELECT * FROM AR)"

Pls guide me. Thks