[thelist] [SQL] INSERT INTO syntax
Tim Burgan
email at timburgan.com
Tue Jan 25 06:59:22 CST 2005
Ken Schaefer wrote:
> Please post *exact* error messages. That makes it much easier to
> research and
> issue and avoids a lot of well intentioned guessing about what be possible
> causes.
What wasn't exact about my error message? I just copied and pasted
directly from the browser window.
> That said, if you are getting an 80040e14 (Syntax error in INSERT
> INTO) then
> you should look here:
> www.adopenstatic.com/faq/80040e14.asp
Your site says to surround field names with [ ]. This is very handy to
know.. and would've solved my problem. I thought I'd previously looked
at this page, but I must have missed it.
> A list of reserved words can be found here:
> http://support.microsoft.com/?id=248738
Thank you for this link.
Tim
More information about the thelist
mailing list