Insert Into syntax error

**LF83** · 09-25-2012, 05:17 PM

Good night, Guys!

I'm trying unsuccessfully to make a "SQL Insert Into" works. I got a message saying "insert into syntax error".

That's the statement:

Please Login or Register  to view this content.

What supposed to be wrong?

Thanks for your attention!

**LF83** · 09-25-2012, 05:28 PM

full code, If helps:

Please Login or Register  to view this content.

**sbkeenan** · 09-25-2012, 05:33 PM

I'm no expert, but I would try removing the double quotes and the ampersand at the beginning of the 4th line in your code? It might also make things a little clearer if you only use double quotes to enclose the whole string and single quotes inside.

**LF83** · 09-25-2012, 05:45 PM

sbkeenan,

I tried what you suggested but it didn't work.

Anyway, thank you for your help.

[]'s

**sbkeenan** · 09-25-2012, 05:55 PM

I think you may also need to enclose the values in brackets.

**mike7952** · 09-25-2012, 05:55 PM

Is tblcadprocesso the Sheet Name your tring to Insert into, if not try the sheet name.

**LF83** · 09-25-2012, 09:48 PM

Guys,

I got the solution. The problem was in how I was concatenating strings like sbkeenan indicated.

The correct syntaxe is:

Please Login or Register  to view this content.

Thank you very much, guys!

[]'s

Insert Into syntax error

LinkBack

Thread Tools

Rate This Thread

Display

Insert Into syntax error

Re: Insert Into syntax error

Re: Insert Into syntax error

Re: Insert Into syntax error

Re: Insert Into syntax error

Re: Insert Into syntax error

Re: Insert Into syntax error

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions