use an sql insert statemant with a comma value

[snorri]

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

[Andy]

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

[techgnome]

You have to strip it of the comma character.

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