I was trying it from a linked Excel Spreadsheet.
strSQL = "INSERT INTO dbo_ESC_tblAllDeedOfTrustSecuredLoans ( [Institution Code], [Institution Abbreviation], [Account Number], [Application Number], [Source Application Code], " & _
"[Account Status Description], Origination_Date...