tags:

views:

16

answers:

2
Q: 

SQL Server 2005 Converting Data Type Error

I am trying to import varchar data into a varchar data type field but I am getting a conversion error of varchar cannot be converted to date type bit? How is that when both fields are already varchar type?

Conversion failed when converting the varchar value 'JOHN KUCHTA' to data type bit.

A: 

If you are importing from CSV, for example, you likely have a missing column in one row, or some of the data is incorrect. Is at least one of the fields you are trying to import of type bit?

RedFilter  2010-08-15 20:34:34
yes there are other fields that are type bit... and I have tried to match all of the types up now that the table is in my database but not in teh production table set.
JOELL  2010-08-15 20:43:01
A: 

I looks like you are inserting into the wrong column or you have mismatched the columns

SQLMenace  2010-08-15 20:34:38
I have checked both tables and both are the same name and both are varchar(30) data types. SQL let me import the table but now I am trying to import it into Production table and thats where the breakdown is. I dont know what to try next. There is only one field named this in the two tables. What else can I try? Does that make sense that I already have the table in the database loaded but now I want to add those values from the import into the Production table. My SQL code is:insert PROFselect * from chicago_testJOELL
JOELL  2010-08-15 20:38:15
list out the columns, it is possible that the tables don't have the columns in the same ordinal position
SQLMenace  2010-08-15 21:54:24

related questions

SQL Server, convert a named instance to default instance?
Natural (human alpha-numeric) sort in Microsoft SQL 2005
In MS SQL Server 2005, is there a way to export, the complete maintenance plan of a database as a SQL Script?
Does ReadUncommitted imply NoLock
Query to list all tables that contain a specific column with SQL Server 2005.
Can I maintain state between calls to a SQL Server UDF?
What are the benefits of using partitions with the Enterprise edition of SQL 2005
Upgrading Sharepoint 3.0 to SQL 2005 Backend?
What's the simplest way to execute a query in Visual C++
Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?
Create a database from another database?
What's the fastest way to bulk insert a lot of data in SQL Server (C# client)
SQL 2005 Book For Optimization Techniques
How do I create a mapping table in SQL Server Management Studio?
Cannot Add a Sql Server Login
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Diagnosing Deadlocks in SQL Server 2005
SQL2005: Linking a table to multiple tables and retaining Ref Integrity?
How to create a new instance of Sql Server 2005
SQL Server 2008 vs 2005 Linq integration
How do you kill all current connections to a SQL Server 2005 database?
Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
SQL Server 2005 and 2008 on same developer machine?
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting