Why do I get 'Syntax Error in INSERT INTO Statement' with Access?
Aside from an actual syntax error in your SQL statement, such as a misplaced quote, comma or bracket, the most common cause for this error is by using a reserved word as an alias, column name or table name. For a list of reserved words to check against your statement, see:
There is one word that keeps cropping up as the source for this error -- at least in Access -- though it is not documented in the above article: password.
If you cannot change the name of the column that is using this reserved word, wrap it in  brackets. E.g.:
Next, check your delimiters. You might get this if you try to delimit a numeric field with an apostrophe or quote, or a date column with the wrong delimiter, or leave a string without a delimiter.
Finally, if you're still having a problem, change:
That should point out the problem. If it doesn't, post your code, the resulting SQL, and your data structure to microsoft.public.inetserver.asp.db and someone will try and help you.
Related ArticlesCan I fix this mm/dd/yyyy <-> dd/mm/yyyy confusion once and for all?
Could I get some help with JOINs?
How can I tell which version of MDAC I'm running?
How do I access MIN, MAX, SUM, COUNT values from SQL statements?
How do I change column order in a table structure?
How do I change the order of columns in a table?
How do I concatenate strings from a column into a single row?
How do I convert columns of values into a single list?
How do I determine if a database exists?
How do I document / compare my SQL Server database(s)?
How do I get the IDENTITY / AUTONUMBER value for the row I inserted?
How do I solve 'ADO Could Not Find The Specified Provider'?
Should I use BETWEEN in my database queries?
Why can't I use the * wildcard in a database search?
Why do I get weird results when using both AND and OR in a query?
Why do some SQL strings have an 'N' prefix?
Why does AbsolutePosition return as -1?
Why doesn't SQL Server allow me to separate DATE and TIME?
Why is Query Analyzer only returning 255 characters?
Why should I avoid NULLs in my database?
How do I deal with an apostrophe (') in a SQL statement?