copy data from one table to another

[Douglas J. Steele]

Get rid of the parentheses around the field names in the SELECT
substatement:

db.Execute "Insert into tblattendance
(studentclocknumber,programcode,coursenum,logintime,logouttime,exempt,shours
) Select
student_clock_number,program_code,course_number,Login_time,Logout_time,exemp
t,S_Hours from bltempattendance"

 

[bob]

I am trying to copy data from one table to another and I
am using the code...

And it is giving me a syntax error. Can someone please
help me?




db.Execute "Insert into tblattendance
(studentclocknumber,programcode,coursenum,logintime,logoutt
ime,exempt,shours) Select
(student_clock_number,program_code,course_number,Login_time
,Logout_time,exempt,S_Hours)from tbltempattendance";