copy data from one table to another

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";
 
L

losmac

Was:
....Logout_time,exempt,S_Hours)from tbltempattendance...
Is:
....Logout_time,exempt,S_Hours) From tbltempattendance...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy data from one table to another 1
copy records from one table to another 1
Copy and paste slide from one presentation to another presentation gives an error 2
unbound fields reordset error 1
unbound fields recordset error 0
insert query for a recordset 4
insert query for a form recordset 13
problem with recordset 1

Top