Currency type

I'm trying to insert into a sql server db. One of the fields in the sql server db is of currency type. The variable that contains the data to be saved to the sql db is of currency type also. However, I get a Type mismatch, when I execute the sql code. I'm using ADO.

Thanks.

post your code

Are you sure you not trying to insert a NULL value?

Doh, I was doing something really stupid. I must have been half asleep. I'll look into it more next time before I decide to post!

Thanks.