SQL - INSERT ??

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

What you posted should work if ACC and AR have the same structure.

Both the table got the same number of field but the error message keep coming out syntax error in INSERT INTO statement ??? Thks

Try to remove the parenthesis.

Insert Acc Select * From Ar

Regards,

------------------

Serge

Software Developer
[email protected]
[email protected]