Here is the syntax, I am using application to create the sql statement string

dim MoneyValue as double = 123.99

sql = "insert into mytable (mymoney) values (123.99)"

if the regional setting is US format then it is inserting OK due the decimal sign is period

If the regional setting is itallian then it is giving error due to the following syntax.

sql = ""insert into mytable (mymoney) values (123,99)"

Note: it is using comma for the decial seperator