copy data from one table to another

  • Thread starter Thread starter Douglas J. Steele
  • Start date Start date
D

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"
 
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";
 
Back
Top