SQL - INSERT ??

[SAMS]

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

[JHausmann]

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

[SAMS]

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

[Serge]

Try to remove the parenthesis.

Insert Acc Select * From Ar

Regards,

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

Serge

Software Developer
Serge_Dymkov@vertexinc.com
Access8484@aol.com