This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 43%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOR%3C/text%3E%3C/svg%3E)
Here is my SQL INSERT statement
sSqlInsert = "Insert into GruppoColl Values (12343009,TRUE,'30/06/2022 11:57:35',RD,Descrizione,TRONCHETTI_RAME_12.IPT,20050082,'Tipo B','Bombato',0,oransen,'In')"
Here is the error message:
HResult=0x80040E10
Message=No value given for one or more required parameters.
I know 'In' is a reserved word and that 'Tipo B' has spaces so I've put them in single quotes.
Here is the definition of the table in Access:
I've clearly missed something, but what?
You have labeled your question sql-server-general, but you start to talk about Access. That's a different product, and you should change the tag accordingly.
The error message, however, suggests that the error message is due something else in the program code that you don't show us. Like you are defining parameters, but do not provide values for them.
Then again, it may be due to those missing single quotes that Olaf points out below
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Owen Ransen ,
Hope everything goes well. Since your question is about Access, I have changed your tag to office-access-dev.
Best regards,
Seeya
That isn't MS SQL Server, it's MS Access, right?
Values (12343009,TRUE,'30/06/2022 11:57:35',RD,Descrizione,TRONCHETTI_RAME_12.IPT,20050082
What's "Descrizione" and the others; it's not a fix string literal?
Try with:
sSqlInsert = "Insert into GruppoColl Values ('12343009',TRUE,#2022/06/30 11:57:35#,'RD','Descrizione','TRONCHETTI_RAME_12.IPT','20050082','Tipo B','Bombato',0,'oransen','In')"