Microsoft JET Database Engine (0×80040e14) Syntax error in FROM clause
Syntax error in FROM clause
This commonly occurs when you have a table name that is a reserved word or your table name contains a space
(eg “table 1″).
Certain words (like table, field, date, select, password, level etc) are reserved by either ADO, OLEDB or by Access
for use as commands or system objects.
You should never use these words as names for tables or fields nor should you have spaces in your tablenames. It
is recommended that you rename your offending tables/fields and adjust your SQL statement accordingly.
If this is not possible you should enclose your offending table names with [ ] marks, eg
SELECT field1
FROM [table]
Syntax error in INSERT INTO statement.
This commonly occurs when your field name is a reserved word (see scenario 1 above). Adjust your field names and
SQL statement accordingly and you should avoid the problem.
If you can’t adjust your fieldnames you can use [ ] marks to delimit the field names, eg
INSERT INTO table1
([field], [password])
VALUES (’value1′, ‘value2′)
