469,277 Members | 2,073 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,277 developers. It's quick & easy.

What does this error message mean? "Error converting data type varchar to numeric"

AAPWM
3
Hello

My job is to extract data from my companies database with Crystal Reports, export that data to Excel, modify the data, save the data as "Text "tab delimited"", and upload to the database once again. Ive done this for close to a year and have never had this error message.

"Error converting data type varchar to numeric"

2255;2801
IMPORT LOG;IMPORT MAPPING INTERFACE;IMPORT MAPPINGS;SQL - CALL IMPORT ROUTINES;_DB ERROR

Can anyone help?
Aug 3 '10 #1
5 5056
code green
1,726 Expert 1GB
I usually see this where I am using a string and a number in the same place.

A typical example would be where the data is usually a price,
but where the price is zero you are replacing with an empty string '' or something like 'No Price'
Aug 4 '10 #2
NeoPa
32,172 Expert Mod 16PB
I agree. You need to look at the data. Anything that indicates which record the error message is referring to is helpful.

I would also look for a number mixed with text, especially where this is just a number in other records. For instance, a currency column may contain a value for CAD (Canadian Dollars) generally, but a value for USD or GBP (pounds sterling) may be written as '32 USD' or '57 GBP'.
Aug 4 '10 #3
AAPWM
3
Thanks people, I do have a column containing weights of certain products. Some of the weights were "0.0". I will try the upload tonight, without the weight column.
Aug 4 '10 #4
AAPWM
3
Hello,

I have found that if you hit Ctrl + Shift in excel while you are typing in a cell, this will change some of your keyboards keys to weird symbols or letters with accents. I did this once without knowing how and decided to keep working with it, all i needed was a quotation sign. I do believe that is what gave me the error message.

Thanks again
Aug 16 '10 #5
NeoPa
32,172 Expert Mod 16PB
I can't say I know much about Ctrl-Shift usage with the keyboard, but I do know that some characters that look like quotes are often inadvertently used in place of the correct ones, and these cause various problems.

They normally show up when code is posted in here properly in the CODE tags though. Especially if you know what you are looking for. They often find their way in when people work with code or data from within a word processor or other such software. MS Word is specifically designed to use slanted quotes if it can, to make it more human-readable. This is fine for humans, but the characters themselves are not what they appear to be, which is critical when used as data or code.
Aug 17 '10 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Kevin Parkinson | last post: by
5 posts views Thread by Bruce Schechter | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.