Hi Guys
I have an excel spreadsheet that contains values i want to insert into a database.Basically my VBA code loops through the named range and inserts the values row by row.
The problem is one of the fields in the database only takes values of float datatype and my insert query is failing because that value is being passed as a varchar from the spreadsheet and i dont know where i can change that fields' value to float.

The query is like this.
Please Login or Register  to view this content.
The price field(6.12 ) is accepted as float on the database but is of varchar in excel.

Where and how can i change the varchar price value to a float thats accepted to database?.

Thanks in advance