Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2008-08-11 : 16:59:41
|
| I am using SSIS Import and Export Wizard for loading the data from Excel into a SQL 2005 database table. The source excel column has values like A, A101,B100,C,12,11,100,2000. The values: A, A101,B100,C are getting loaded into the SQL table, but the numbers 12,11,100,2000 are getting loaded as nulls into the SQL table. The datatype for that column in the table is varcha(255). Please advice. Thanks!! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-11 : 22:30:42
|
| Double check last 4 columns in excel, ensure they have same type of data (all numbers in this case). |
 |
|
|
|
|
|
|
|
Data loading issue from Excel