SQL syntax error - HELP PLEASE 3

[datavisions]

I'm getting a syntax error on the SQL below now and after staring at it for FIVE hours now I'm about to go mental. Can someone help me please?

Public Function ParseAndStoreAADetailRecord(GFile)
On Error GoTo Err_Handler

Dim db As Database

Dim AN As String
Dim RC As String

Set db = DBEngine(0)(0)

AN = Mid(GFile, 1, 12)
RC = Mid(GFile, 107, 30)

db.Execute "INSERT into tblAAAccidentTemp(" _
& "OldAccountNumber, " _
& "RejectCode)" _
& "VALUES (" & AN & _
"," & RC & ""

End Function

 

[datavisions]

I used to manage hockey! I have another question about importing so I'll post a new thread here in a sec.