troubleshooting Question

SQL microsoft access  syntax error

Avatar of weaverk
weaverkFlag for Switzerland asked on
Microsoft AccessSQL
4 Comments1 Solution460 ViewsLast Modified:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/class/ObjectSQL.inc, line 52

i get this error using the code snippet attached, i must be missing the error in the query...

any help to find it will be much appreciated!
thanks

INSERT INTO FREEPRODUCT
(FREEPRODUCT_ID, AREA_ID, FREEPRODUCT_Title, FREEPRODUCT_Description
, FREEPRODUCT_Sources, FREEPRODUCT_LastUpdated, FREEPRODUCT_GLIDE
, FREEPRODUCT_Folder, FREEPRODUCT_MinX, FREEPRODUCT_MaxY, FREEPRODUCT_MaxX
, FREEPRODUCT_MinY, FREEPRODUCT_Img, CoverImage, Image, FREEPRODUCT_URL1
, mapLink, FREEPRODUCT_Size1, FREEPRODUCT_URL2, mapLink2, FREEPRODUCT_Size2
, SHP_Link, GDB_Link, KML_Link, WMS_Link, PTypeStat, SC_Data, NV_Data, GP_Data
) VALUES(1660, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros