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:56: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 |
|
|
mikgri
Starting Member
39 Posts |
Posted - 2011-04-20 : 10:09:12
|
| Format all cells in excel as text.Right click on column then -> insert, new column will be added. In the first row type =trim( and lick on first cell of column you would like to reformat (ex: G1), and close parentheses ), then copy data in entire column, highlight column you would like to reformat, choose "Paste Special", click potion "Values" and OK.All data in column will be formatted as text.Hope it will help |
 |
|
|
|
|
|
Import Wiz Error