Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 error converting varchar to numeric

Author  Topic 

robert_645
Starting Member

4 Posts

Posted - 2015-01-09 : 05:06:04
Hello all,

I insert data from excel to sql using vba.
In this case I try to insert numbers in a sql column with data type decimal (18, 6)
In excel the format of the cells are 'number'
Below a part of the code
[CODE]
Dim as3000 As Double
Dim rec As Double
'...
'...
as3000 = CDec(Cells(mytel2, soort).Value)
rec = CDec(Range("U" & mytel2).Value)
rc.Open "INSERT INTO dbo.QHSE_2ndline_history (AS3000, Rec) VALUES ('" & as3000 & "', '" & rec & "')", con
'...
[/CODE]

But when starting the code, it results in an error converting data type varchar to numeric.
What have I done wrong, please help

Thanks in advance

robert_645
Starting Member

4 Posts

Posted - 2015-01-09 : 08:09:04
I have found the problem(s).
First there were to many quotes. ...VALUES ('" & as3000 --> ...VALUES ( " & as3000
after that the next problem was the decimal separation
My decimal separator was set to a comma. Which gave the problem that it seems there were more results than columns.
Conclusion, use a point as decimal sep.
This item can be closed.
Go to Top of Page

Blackcap145
Starting Member

1 Post

Posted - 2015-02-17 : 01:28:55
when starting the code, it results in an error converting data type varchar to numeric...???


watson
Go to Top of Page
   

- Advertisement -