What is wrong with this insert statement. I pasted the error below. I have used this statement format on other pages for a different table and it worked??
<CFQUERY DATASOURCE="academics">
INSERT INTO GuideVisits (category, Date, Hour, Minute, Meridian, Name)
VALUES('#itemmenu#', '#Date#', '#Hour#', '#Minute#', '#Meridian#', '#Name#')
</cfquery>
ERROR
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:1) to (9:32).
<CFQUERY DATASOURCE="academics">
INSERT INTO GuideVisits (category, Date, Hour, Minute, Meridian, Name)
VALUES('#itemmenu#', '#Date#', '#Hour#', '#Minute#', '#Meridian#', '#Name#')
</cfquery>
ERROR
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:1) to (9:32).
