copy data from one table to another

  • Thread starter Thread starter bob
  • Start date Start date
B

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";
 
Was:
....Logout_time,exempt,S_Hours)from tbltempattendance...
Is:
....Logout_time,exempt,S_Hours) From tbltempattendance...
 
Back
Top