I'm getting a strange error.
When I send this INSERT statement from Excel I get an error 'Syntax error in INSERT INTO statement'.
INSERT INTO tblRegularAttendance(ApplicationID, DayNumber, DayName, Session, RoleTitle, Hospital) VALUES('1234567', 4, 'Thursday', '4AM', 'Driver', 'Guys')
But when I run that in the Query Window in Access it runs ok!
The Connection is the same as I use for other ADO INSERT operations on this application.
Any ideas please?