473,372 Members | 830 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

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 5313
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,556 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,556 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

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

Similar topics

1
by: Ian Lazarus | last post by:
Hello, Project = class library dll implemented in C++ as a managed wrapper around an unmanaged class, and a small project to consume it (shown at bottom). Running the consumer code results in...
3
by: Jeff Smythe | last post by:
I simply want to execute some code once when a new session of my ASP.NET application is started (I'm not using session state for anything else - just writing some data to a database). I thought...
1
by: Kevin Parkinson | last post by:
Hello Eveyone: I was wondering if someone can set me straight on this little problem I am having which I believe must be a configuration issue. Everytime VS.NET creates a new web form and puts...
5
by: Bruce Schechter | last post by:
I just started to develop an ASP.NET application in vs.net 2003 . But each time I try to execute the application (which is basically empty so far), I get a dialog box titled "Microsoft Development...
0
by: rajmgopal | last post by:
Hello Everyone I am getting the following error when i try to insert a record into Sql Server 2005 from my VB 2005 application. sqlEx = {"Error converting data type numeric to numeric."} I...
5
by: dananrg | last post by:
I was messing around with the native ODBC module (I am using Python in a Win32 environment), e.g: import dbi, odbc ....and it seems to meet my needs. I'd rather use a module that comes...
0
by: Ganesh Muthuvelu | last post by:
Hello, What is wrong with this simple schema. When I try to load it to a dataset it gives me an error, "Data type not defined" Thanks. ****************************** <?xml version="1.0"...
22
by: kkk1979 | last post by:
I am not an experienced programmer. I am getting an error as "method or data member not found" when i entered the following code in buttonclick procedure of the toolbar. select case button.key...
2
by: santhanalakshmi | last post by:
hi, I have created a new user in mysql by the root user. user:san password:san when i login into mysql as...
1
by: mikr | last post by:
I'm new to jquery, and hoping it will make my client side coding more friendly (particularly with regards to ie). As is usually the case, I've got some code that works nicely in ff, but kicks out...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.