What is wrong with it????

[Nirious]

I have looked at it and looked again and again and I can't find the problem with this query.

I have a textfile that I read some lines of and that are added to a databasetable:

ArtopBonUpd = "INSERT INTO ArtikelsOpBon (PLUNummer, Aantal, StukPrijsExclBTW, BonNr, Input) " & _
            "VALUES (" & Val(iplu) & ", '" & iaantald & "', '" & iepd & "', " & ibonnr & ", 'w');"
            
            cmd.CommandText = ArtopBonUpd
            cmd.Execute aantalrecs

ArtikelsOpBon's design view is like this:
id = autonumber
PLUNummer = Number
Aantal = Number
StukPrijsExclBTW = Currency
BonNr = Number
Input = Text

The problem started when I added the last field to the table ( "Input").
When I remove the words Input and 'w' from the query, all inserts fine, except for Input ofcourse which is left empty, but when I include the Input, I get the following error:

Run-Time error'-2147217900 (80040e14)':
Syntaxerror in the instruction INSERT INTO.

I have no clue where I made a mistake

 

[fernin8r]

have you check your field types to make sure they match