Okay from your Data Type List I see several issues:

1. You have the value '1' going into an int column. The value should not have the single quotes around it.

2....

Hopefully you can find an answer for your problem in this long thread.

[/url]

Could you please list out all the columns used in the insert with the SQL data types?

Also is the e_id column an identity column? I would bet the problem is...

I don't know if this makes a difference but I was able to suck in an Excel document using SQL 2008 R2's import wizard (OS is Win7 64 Bit) and...

Thanks SSC Rookie. I ended up solving my own problem with this. I wrote a script in SQL Server to output to CSV using BCP. The only problem was the...

All of the tables do have a different structure.