Hi --
I am trying to get some data from Excel to a MS SQL database. I have had a lot of luck with this in the past -- but today I tried to push in some decimal values. I did not get any errors in my VBA code -- but when I went to the MS SQL database it only showed "0's" instead of showing the decimal values. I have retrieved the data back to excel to verify it really was a 0 and not just displaying a 0 because of it being a small number.
My data type in the sql database is decimal(18,0).
Any ideas?
I am trying to get some data from Excel to a MS SQL database. I have had a lot of luck with this in the past -- but today I tried to push in some decimal values. I did not get any errors in my VBA code -- but when I went to the MS SQL database it only showed "0's" instead of showing the decimal values. I have retrieved the data back to excel to verify it really was a 0 and not just displaying a 0 because of it being a small number.
My data type in the sql database is decimal(18,0).
Any ideas?
Comment