Syntax error in INSERT INTO statement,: IN, mWriteInputFiles.sol

1,153 views
Skip to first unread message

Laura Bender

unread,
Apr 5, 2021, 8:53:37 AM4/5/21
to ArcSWAT
Can somebody help me solve this? Occurred during the Write SWAT Tables step. 

Thank you!!! 

Jenny Paola Cantor Suárez

unread,
Apr 21, 2021, 5:35:45 PM4/21/21
to ArcSWAT
Hello, can you solve this? I have the same problem

Stephen Kibe Rwigi

unread,
Apr 23, 2021, 10:13:24 AM4/23/21
to ArcSWAT
Same problem with me.
I thought maybe the problem was with my soil database.

-----------------------------------------
A KEBS 9001:2015 Certified Organization, No. KEBS/QMS/RF:064 Rev. 03

Marcela Duarte

unread,
Apr 23, 2021, 10:42:10 AM4/23/21
to ArcSWAT
Hey guys, I also found this error and my solution was to check if there are any empty cells in the soil database. Analyze all the soil data, if you have an empty cell in the .MDB this problem appears.

Laura Bender

unread,
Apr 23, 2021, 10:42:11 AM4/23/21
to Stephen Kibe Rwigi, ArcSWAT
Hi all, unfortunately I have been stuck on this error for quite some time still.

--
You received this message because you are subscribed to the Google Groups "ArcSWAT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to arcswat+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/arcswat/42f1065c-3813-46c2-aadf-0d6c7eb456e9n%40googlegroups.com.

Jane Li

unread,
Apr 24, 2021, 7:54:10 PM4/24/21
to ArcSWAT
Hello All,
 unfortunately I have been stuck on this error for quite some time too, Sill haven't found an answer yet.

Jane Li

unread,
Apr 27, 2021, 12:58:02 PM4/27/21
to ArcSWAT
Hi,
Finally I solved my "Syntax error in INSERT INTO statement,: IN, mWriteInputFiles.sol" problem.

Here is what I did.  I output the SSURGO soil data from  ACCESS database (downloaded from SWAT website) to an Excel file,  delete the last two columns with empty cells, input the EXCEL SSURGO data as an usersoil to  QSWAT project database, create your soil lookup table . It's working.  

Have a good day.

Stephen Kibe Rwigi

unread,
Apr 27, 2021, 2:29:56 PM4/27/21
to Jane Li, ArcSWAT
This is great!
Mine is yet to work. Maybe because I am outside USA territory and hence have use to load usersoil. 


--
You received this message because you are subscribed to a topic in the Google Groups "ArcSWAT" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/arcswat/58eB7E3pTHk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to arcswat+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/arcswat/a416e34f-5e76-4ed1-9cab-66f25fd07d72n%40googlegroups.com.

Patrick Ehhalt

unread,
May 1, 2021, 2:51:31 PM5/1/21
to ArcSWAT
Make sure your soil raster covers 100%
Delete all SWAT soils databases
Download the old ssurgo database found imbedded in this user group forum ( you'll have to hunt for it, but its hyperlinked)
Extract it in your C: drive
 That's what worked for me after several days of trying! Youre not alone :)

Jenny Paola Cantor Suárez

unread,
May 2, 2021, 1:39:45 PM5/2/21
to ArcSWAT
Thank you for your response I wanted to know if you can share the Ssurgo file as I can't find it, thank you very much

Laura Bender

unread,
May 3, 2021, 2:21:04 PM5/3/21
to Jenny Paola Cantor Suárez, ArcSWAT

You received this message because you are subscribed to the Google Groups "ArcSWAT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to arcswat+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/arcswat/0bc51c26-2a2e-4167-b13d-88636ba3e26dn%40googlegroups.com.

Amanda Nana Ama Arthur

unread,
Sep 18, 2023, 2:36:43 PM9/18/23
to ArcSWAT
Thank you
Reply all
Reply to author
Forward
0 new messages