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 |
|
satheesh
Posting Yak Master
152 Posts |
 Posted - 2011-04-15 : 06:58:32
|
| Dear All,I am tried to upload excel data in to sql DB using Sql Import and Export Wiz.All numeric data in a field for ex:449123,2965642 uploaded successfully.But all alfanumeric data for ex AA56575,TGH7546 is uploaded as 'NULL' in to sql.Any one please tell me what may be the reason.I need to upload all the data for excel in to sql DBRegards,SG |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-04-15 : 07:56:31
|
| Does it think these are numeric columns and so is unable to convert? This often happens if the initial rows in excel contain numeric data.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Import Wiz Error