use an sql insert statemant with a comma value

HI.

my problem is that I am trying to put a commavalue into a database, useing an insert statement.

the sqlcommand goes kinda like this:

insert into tbl1 (value1, value2) values (" & DTMain.CellSet(Row, 5).Value & ",'" & DTMain.CellSet(Row, 6).Value & "')"




the float value(number)
the string value


please help me.

best regards snorri

what problems are you having? is it not accepting the syntax or what?

You have to strip it of the comma character.

VB Code:

insert into tbl1 (value1, value2) values (" & Format(DTMain.CellSet(Row, 5).Value, "###0.00000") & ",'" & DTMain.CellSet(Row, 6).Value & "')"

If you leave the comma in there, SQL will misinterpret the comma as the field delimiter and return an errror.

TG