Inserting values from one table to another

[dada]

here is my table structure

Table Name: DTR


Field Name - Data Type:
EmpNum - Text
Empname - Text
Date - Date/Time
Day - Text
FIN - Date/Time
FOUT - Text
LIN - Date/Time
LOUT - Date/Time

Table Name: TempDTR
Field Name - Data Type:
F1 - Text
F2 - Text
F3 - Date/Time
F4 - Text
F5 - Date/Time
F6 - Text
F7 - Date/Time
F8 - Date/Time

here is my code:

DoCmd.SetWarnings (False)
Dim sql As String

sql = "INSERT into DTR(EmpNum, EmpName, Date, Day, FIN, FOUT, LIN, LOUT) Select F1,F2, F3, F4, F5, F6, F7, F8 from TempDTR"
DoCmd.RunSQL (sql)


It gives me syntax error and i don't know why.. any idea? please help..

[jzwp11]

Your field called Date is probably causing the problem since Date is a reserved word in Access (the Date() function). For the short term, you could enclose the field in square brackets.

sql = "INSERT into DTR(EmpNum, EmpName, [Date], Day, FIN, FOUT, LIN, LOUT) Select F1,F2, F3, F4, F5, F6, F7, F8 from TempDTR"
        DoCmd.RunSQL (sql)

For the long term, it would be best to give the field a new name.

Here is a link to a list of reserved words in Access 2010 and another link for Access 2003

[dada]

awesome! you nailed it! i got one more question but it's a different topic, so i'll just post another thread. thanks dude!

[jzwp11]

You're welcome!