Re: ADOConnection INSERT INTO error

Found the answer.

YEAR and MONTH are keywords that invalidate the SQL string.

Thanks to this post in 2003!

You probably have error in SQL statement. Check that number of fields
in
table1 (...) is the same as number of parameters values (...), that
field
names do not conflict with SQL keywords (change field1, field2, ... to
[field1], [field2]).

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev

.

Relevant Pages

  • Re: Using VBA to create a Table in Access database
    ... "Set rst = qdf.OpenRecordset" ... in data which forms the WHERE clause of the sql statement. ... i declared qdf.sql = sqlstring followed by ... If you want to modify the code so that you pass in a simple SQL string, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Nested Datalists
    ... This SQL statement returns all the information that I need (Drawing #, ... (MaxOfDCN) ... this SQL string as the DataSource for one of my datalists. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: newbie - sql UPDATE statement
    ... You seemed to refer to the same ... "Newbee Adam" wrote in message ... > I do think a replace function can be used in an sql statement like I use ... > outside an sql string like: ...
    (microsoft.public.access.gettingstarted)
  • Re: How can i get the "true" name of an aliased field?
    ... I'm opening an ADO recordset with an SQL string which goes something ... Use rs.Source to get the sql statement that was used to populate the ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Single Quote in SQL Statement
    ... it is easier to debug in you can construct the SQL String separately ... Dim strSQL As String ... > I need to run a insert sql statement into one of my ... the sub get arguments that need to ...
    (microsoft.public.access.modulesdaovba)